DbVisualizer Error

Published on October 29th, 2006 in General

I downloaded Minq Software’s great DbVisualizer to do some stuff with a MySQL database. I configured the MySQL database driver properly, but DbVisualizer wouldn’t connect to the database with the following error: “Unknown initial character set”. Taking a look at MySQL’s configuration file (located at MySQL/bin/my.cnf), showed that the “character-set-server” property was using latin1 as its standard charset. I changed it to “utf8″ and the following “collation-server” setting to “utf8_general_ci”, restarted MySQL and DbVisualizer would now connect to the database without problems!

1 comment

Leorick Simon August 28th, 2008

Yup, I did the same thing too. Maybe this link could help others - http://xp-rience.blogspot.com/2008/08/dbvisualizer-mysql-characterencoding.html

Shout it out!