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,

I change the connection string to,

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:
Sent from the MySQL - General mailing list archive at

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