Mysql unicode error

[Mousa Shaya]

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]

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