MySQL error after upgrade from Mantis 1.0.2 to 1.1.6

[MarkB]

I have just tried upgrading Mantis from 1.0.2 to 1.1.6. I went through the "Mantis Administration" -> "Upgrade your installation" process, which reported that it had completed successfully. However, when I followed the link to log in to Mantis, I had the following error:

APPLICATION ERROR #401

Database query failed. Error received from database was #1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' for the query: SELECT id
FROM mantis_user_table
WHERE username='administrator'.

MySQL is version 4.1.7.

Is there something else I need to do before or after the upgrade to avoid this problem? Thanks in advance for any help.

[hydiehydie]

I have the same problem.
Would be curious to know what you find out.

[sjenkinsdc]

I am just installing 1.1.7 for the first time and ran into the same error. Here is how I fixed it:

I exported my entire mantis db (drop table and insert table commands), replaced 'latin1' with 'utf8', and then ran the exported sql statements. No more error msg.

[hsiehlc]

this one seems to be a bug of Mantis. I am having the same trouble when I try Traditional Chinese input to a field.
searched the forum and found 5 posts with this same problem and only this one has an answer, but I don't want to mess up with my database (I am not a professional on database). anyone can help at all?