internetworkers AT lists.ibiblio.org
Subject: Internetworkers: http://www.ibiblio.org/internetworkers/
List archive
[internetworkers] mySql JDBC driver not properly escaping characters
- 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
-
[internetworkers] mySql JDBC driver not properly escaping characters,
Tony Spencer, 08/20/2004
-
Re: [internetworkers] mySql JDBC driver not properly escaping characters,
Kevin Sonney, 08/20/2004
- RE: [internetworkers] mySql JDBC driver not properly escapingcharacters, Tony Spencer, 08/20/2004
-
Re: [internetworkers] mySql JDBC driver not properly escaping characters,
Kevin Sonney, 08/20/2004
Archive powered by MHonArc 2.6.24.