Storing special characters(') into oracle

[Praveena Modugula]

How to store special characters(') into oracle database?

[Shailesh Chandra]

Use PreparedStatement


Shailesh

[Praveena Modugula]

Indetail explanation please...with example
Suppose if I want to insert "Sriman's" aganist name DB field...How is this achieved?

[Paul Sturrock]

By binding the String parameter using a PreparedStatement. Change you code to use a PreparedStatement and you'll see how it works.

[stu derby]

Originally posted by Praveena Modugula:
Indetail explanation please...with example
Suppose if I want to insert "Sriman's" aganist name DB field...How is this achieved?

http://www.google.com/search?q=preparedstatement+tutorial

Any of the first few results will tell you want you need to know.

[Anand Nautiyal]

try it by first replacing (') by \\' in the string

[Eleanor Leong]

You can also add a "'" to your sql statment.
For e.g
insert into Restaurant (name) ('Nick''s Place');
will insert a restraurant name Nick's Place.


Eleanor Leong