Mysql unicode error

Question

I have configured my MySQL database to have the following collation:

CREATE DATABASE `crucible` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */

When I try to configure crucible to use my MYSQL db I get this error:

The database is not using Unicode. Crucible requires that the database uses a UTF8 encoding to support internalization.

2011-08-22 08:32:21,368 ERROR - MySQL DB is using collation 'utf8_unicode_ci'

These are the paramteres that I am using:

useUnicode=true
characterEncoding=UTF8
connectionCollation=utf8_unicode_ci

How can I use MySQL database with crucible?

Tom Davies · Answer

FishEye expects the collation "utf8_bin", as a case insensitive collation can cause problems when a file's path or name differs only in case. See http://confluence.atlassian.com/display/FISHEYE024/Migrating+to+an+External+Database#MigratingtoanExternalDatabase-MigratingtoMySQLEnterpriseServer