This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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: 174

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.
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: 565
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.
 
 
subject: Inserting strings with quotes
 
Similar Threads
Escape Character in String Parsing
Regular expression confusion
EL Escape Character?
quote inside quote inside quote
Regex splitting on carat symbol