• Welcome to Simple Machines Community Forum. Please login or sign up.
November 28, 2021, 10:32:49 AM

News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord


[SMF 2.0.8] Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and .. ERROR

Started by Rain Forest, December 28, 2014, 07:50:51 AM

Previous topic - Next topic

Rain Forest

People on my forums are complaining that their username + ascii code (e.g. this ascii sign: ♥) are giving them '?' instead of the ascii sign/code. After I tried it myself I got the following error.

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
File: /home/.../Sources/Subs-Members.php
Line: 1006


As I am a rookie in Database or advanced coding I have no idea what to do. My forum has always been with UTF-8 characters (if it's any helpfull).

hopefully someone could help me :)

Subs-members.php is added as attachment.

Kindred

look in your database and confirm that all of the tables AND columns are indeed UTF8
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.<br /><br />"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Rain Forest

Is there a simple query to convert all tables to utf8?

E.g
ALTER TABLE ALL CONVERT TO CHARACTER SET utf8;

Just checked it and saw that all it are UTF8..

Kindred

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.<br /><br />"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."


Kindred

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.<br /><br />"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Rain Forest

All colums are latin1_swedish indeed..

I have no clue, even on that link how to change/convert all colums to UTF8.. :(

Kindred

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.<br /><br />"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Rain Forest


Horme Gaming

Dragon Fruit do you still need help with this?  If so can you tell us what else you have tried please :D

Advertisement: