aspose file tools*
The moose likes JDBC and the fly likes Inserting strings with quotes Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Inserting strings with quotes" Watch "Inserting strings with quotes" New topic
Author

Inserting strings with quotes

Carey Brown
Ranch Hand

Joined: Nov 19, 2001
Posts: 210

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.


Sent from my IBM 360 mainframe
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

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
Dorothy Finkel-Laverty
Ranch Hand

Joined: Nov 24, 2001
Posts: 51
Jamie - is that two single quotes between the O and R? Or a double quote?
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

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
Adam Hardy
Ranch Hand

Joined: Oct 09, 2001
Posts: 566
O'Really? ;-)
It'll mess up your HTML & Javascript too if you're not careful.

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.
 
Don't get me started about those stupid light bulbs.
 
subject: Inserting strings with quotes