Escaping special characters

[Gopi Chand Maddula]

Hi JavaRanch,

I had a problem inserting my customer details in database. I have to insert customer into database as a column.
but i am facing a problem facing some values(for example: Queen's Court.),
Here my problem is inserting this value into database is not possible which should be done as it is.

Can any one please suggest me to overcome this problem in my java code.

Thanks in Advance...!

[Raj S Kumar]

Hi Gopi,
Please try this issue in the JDBC forum. You could get answers from there as it is specific to JDBC.

[Rob Spoor]

Moving there.

[Gopi Chand Maddula]

Hi Raj,

Thanks for Reply,

But i need to escape the bad characters in string before inserting into database.
so that i can use that code for verifying some other conditions also....!

Is it possible....?

[David Newton]

SQL escape it, or use a prepared statement?

[Jeanne Boyarsky]

Gopi,
I recomment using a prepared statement unless you have a really good reason not to. It takes care of escaping such values for you when you call stmt.setString().