Cureless

Got the following SQL error while trying to login to a newly deployed Appfuse-based web app:

#1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

It turned out I wasn’t using the proper database encoding. I created a new database (using DBToolsManager) and changed the encoding of the new database to utf-8.

This entry was posted on Wednesday, February 22nd, 2006 at 1:21 pm and is filed under Programming. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.