Skip to Content.
Sympa Menu

internetworkers - [internetworkers] mySql JDBC driver not properly escaping characters

internetworkers AT lists.ibiblio.org

Subject: Internetworkers: http://www.ibiblio.org/internetworkers/

List archive

Chronological Thread  
  • From: "Tony Spencer" <tony AT tonyspencer.com>
  • To: "'Internetworkers: http://www.ibiblio.org/internetworkers/'" <internetworkers AT lists.ibiblio.org>
  • Subject: [internetworkers] mySql JDBC driver not properly escaping characters
  • Date: Fri, 20 Aug 2004 10:01:50 -0400

Isn't it the duty of my JDBC driver to handle proper escaping of characters
before performing an insert into my mySQl database?

Here's my problem. I have some text occasionally contains characters such
as:

'
"

When perform an INSERT with this text those characters appear as a question
mark in the database. I'm using the latest production version of the
official driver (MySQL Connector/J 3.0.14).

Much thanks in advance to any insight.

MySQL doc on escaping characters:
http://dev.mysql.com/doc/mysql/en/String_syntax.html





Archive powered by MHonArc 2.6.24.

Top of Page