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.
look in your database and confirm that all of the tables AND columns are indeed UTF8
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..
http://stackoverflow.com/questions/6050014/how-do-you-change-the-collation-type-for-a-mysql-column
All colums are latin1_swedish indeed..
I have no clue, even on that link how to change/convert all colums to UTF8.. :(
I believe that the subcommand, after the alter statement is convert
Errr, ok. :P
In English?
Dragon Fruit do you still need help with this? If so can you tell us what else you have tried please :D