Linux MySQL Error

Saturday, December 27, 2008

if you try to use jdbc to connect to a MySQL database on a Linux distribution like Fedora or Redhat and get the error:

java.sql.SQLException: Unexpected exception encountered during query.
Caused by: java.io.CharConversionException

Solution:
modify /etc/my.cnf add the line:
default-character-set=utf8

You can also use a more recent version of java.

Labels: Technology