List:General Discussion« Previous MessageNext Message »
From:prt Date:March 23 2007 5:47pm
Subject:Data truncation: Data too long for column....
View as plain text  
Hi to all,
I developed java web application that runs on tomcat5 and MySQL 3.23.54,
MySQL connector is mysql-connector-java-3.1.12-bin.jar.
And everything work good.

I Whant to change the MySQL to 5 version.
So i install MySQL 5.0.27.
Use MySQL connector mysql-connector-java-5.0.5-bin.jar.

My web application is in Hebrew language.
The problem is now that i get Exception when i try to update or insert
Hebrew string (only 2 letters length) to DB.
I get this Error..
"com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for
column ... "

The connection string is,
url="jdbc:mysql://localhost/db?useUnicode=true&characterEncoding=iso-8859-8"

I change the connection string to,
url="jdbc:mysql://localhost/world?useUnicode=true&characterEncoding=iso-8859-8&jdbcCompliantTruncation=false"

Now i dont get Error,
"com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for
column ... "
But the Hebrew data is look like this "???"

What can i do to fix that problem ? 
With MySQL 3.23.54 i have no such problem, everything work perfect.

Thank you all and sory about my bad English.
-- 
View this message in context:
http://www.nabble.com/Data-truncation%3A-Data-too-long-for-column....-tf3455352.html#a9639972
Sent from the MySQL - General mailing list archive at Nabble.com.

Thread
Data truncation: Data too long for column....prt23 Mar