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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
