SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 06:04 AM
| ||||
| ||||
 Data truncation: Data too long for column.... 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-truncatio....html#a9639972 Sent from the MySQL - General mailing list archive at Nabble.com.      |
Linear Mode
