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.
