How to handle quotation marks in varchar fields?

James Foreman · #1 (**permalink**) 05-15-04, 12:35

I've got some customer data where some names will have ' within them (eg O'Brien). The data comes through in all upper case; although we can format most names correctly by putting it into lower case (except for the first letter), I don't see how to deal with changing letters after a '. How do you refer to a ' mark without DB2 thinking you're just giving the first ' mark in referring to a string?

(DB2 8.1.2 on Suse 8)

n_i · #2 (**permalink**) 05-15-04, 14:28

To escape a single quote character you need to double it - put two single quotes together. For example:

Code:

INSERT INTO USERS (LAST_NAME) VALUES ('O''Brien') WHERE USER_ID = ?

Internet Services

Web Development

Digital Marketing

Consumer Tech