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 special characters in queries 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 "special characters in queries" Watch "special characters in queries" New topic
Author

special characters in queries

pavanasree vasireddy
Ranch Hand

Joined: Jun 12, 2004
Posts: 34
I have a problem with special characters in java.

I am entering a big string which may consist of special character especially quotes("). I need to insert in to the database as string. I am using MYSQL.
In MySql Strings need to be enclosed with quotes.

My problem is when i insert strings which consists of quotes it is giving error as it is not able to identify the quotes that are enclosed and the quotes that are within the string.


please help me in this regard.

[EJFH: Added meaningful subject ]
[ August 12, 2004: Message edited by: Ernest Friedman-Hill ]
Ernest Friedman-Hill
author and iconoclast
Marshal

Joined: Jul 08, 2003
Posts: 24183
    
  34

Use the java.sql.PreparedStatement class. You prepare your query using question marks ("?") as placeholders, and then PreparedStatement does the work of escaping the special characters in your strings for you. Works great.

I'm going to move this to our JDBC forum for followup.


[Jess in Action][AskingGoodQuestions]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: special characters in queries
 
Similar Threads
Regex to split string on condition
how to read a file in a string
String replace function with single quote
Problem in inserting special characters
Can't insert Data