Inserting special characters in DB2

div17283 · #1 (**permalink**) 04-02-10, 08:38

how to insert semicolon using query?

ARWinner · #2 (**permalink**) 04-02-10, 08:56

INSERT INTO MyTable (Col1) values (';')

Andy

div17283 · #3 (**permalink**) 04-02-10, 09:02

by the way prob solved. i have used CHAR(59) in place of semicolon

Peter.Vanroose · #4 (**permalink**) 04-06-10, 16:19

Quote:

Originally Posted by div17283

by the way prob solved. i have used CHAR(59) in place of semicolon

This only works if you know the database encoding. E.g., if it is EBCDIC, you'd need CHAR(94) instead of CHAR(59). The latter works for ASCII en Unicode, though.

Internet Services

Web Development

Digital Marketing

Consumer Tech