Is there an escape sequence that you can use to insert a string that contains a single quote? e.g.; "Carey's data". I tried a backslash but it didn't work, the backslash actually ended up in the database.
The easiest way is to use a PreparedStatement instead of Statement. PreparedStatements automatically escape these troublesome characters. The other method is to escape single quotes with another single quote: "insert into ... values ( "Sam", "O''Reilly" ) this will insert "O'Reilly" into the database. Jamie
Joined: Nov 24, 2001
Jamie - is that two single quotes between the O and R? Or a double quote?
you've probably figured this out by now, but you are right, it should be: "insert into ... values ( 'Sam', 'O''Reilly' ) this will insert O'Reilly into the database. Jamie
Joined: Oct 09, 2001
I have seen things you people would not believe, attack ships on fire off the shoulder of Orion, c-beams sparkling in the dark near the Tennhauser Gate. All these moments will be lost in time, like tears in the rain.