Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Are resultant database values automatically stripped of any escaping?

843854Feb 20 2003 — edited Feb 24 2003
Hello, my question is very simple:

When using JDBC, are the values that result from a SELECT query automatically stripped of all escaping characters, such as backslashes, that may have been added when data was added to the database?

I ask this because in PHP, one must add slashes to escape single quotes manually, while in Java, a PreparedStatement will automatically do this.

I am just curious if Java will automatically remove any slashes that may have been added to escape single quotes?

If so, what if just a Statement was used and the programmer added the escaping himself. Would Java still return values that have already been stripped of SQL statement escaping?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 24 2003
Added on Feb 20 2003
5 comments
236 views