com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'DATA_COLUMN' at row 1

I am using the largest datatype I can, LONGTEXT or LONGBLOB, and still get the above, the data can't be that large, so I have no idea. -- Ravi Gupta Solutions Architect JBoss by Red Hat, Inc. Email: rgu...@redhat.com | c: 773.544.6894 | http://www.redhat.com -- MySQL General Mailing

JDBC error: sql: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'gname' at row 0

Have identical versions installed, in one query works fine, in another, pukes with the error in the subject. When I query by hand (via mysql client) works fine. Not even that much data to complain about! mysql> select -> group_concat(concat('',hosts.name,'') order by hosts.name asc separa

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

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=&