java.sql.SQLException: Data truncated for column at row 1

[bsonline]

Hi all,

When I update a table by sql qry, I am getting a error like "java.sql.SQLException: Data truncated for column [column_name] at row 1" . I use mysql 4.1 for my application.
this particular column is in varchar with length 10.

Can anyone help regarding this??

[JosAH]

Most likely you attempted to store a String with more than ten characters in
that column.

kind regards,

Jos

[bsonline]

Most likely you attempted to store a String with more than ten characters in
that column.

kind regards,

Jos

But the data is exactly of 9 character and its constant.

[JosAH]

But the data is exactly of 9 character and its constant.

I don't use mysql myself but I suspect that a char in a varchar is an eight bit
quantity and Java's char is a 16 bit quantity; some encoding is happening
(most likely). Try to change your table column to varchar 20 or so and see
what happens.

kind regards,

Jos