-----Original Message----- From: Ylan Segal [mailto:yl...@digiworks.tv] Sent: 14 September 2001 17:10 To: ja...@lists.mysql.com Subject: String with " charatchter fails is truncated on INSERT

My problem is as follows:

I have developed a web-application using tomcat and mysql. The problem is that Strings that contain the character " (double-quote) are not being stored properly in mysql, what is happening is that the String is being truncated at the first appearens of the " character.

Now, if I print the String to console or web-page the Strig is NOT truncated and it is properly displayed. I am pretty sure the problem lays in the INSERT statement.

I am using mm.mysql latest drivers. My code looks like this:

..... String query = "INSERT INTO MyTable VALUES(NULL, ?)"; //The null is for an autoincrement field and second field is a VARCHAR field. PreparedStatement = con.prepareStatement(query); //con is a java.sql.Connection ps.setString(1, myString); //my String is the string with the " charachter. int count = ps.executeUpdate(); .....

Is this a problem with the driver that is not escaping the " character properly? Does anybody have a solution?

Thanks a lot for your help.

_____

--------------------------------------------------------------------- Please check