type error : database

[rednet]

huy, anyone can help me? i have error with this messages :

Code Select Expand

http://mydomain.org/index.php?action=profile;area=account;save=
Database Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'


SELECT id_member
FROM smf_members
WHERE id_member != 1
AND (real_name LIKE '??????' OR member_name LIKE '??????')
LIMIT 1
File: /home/mydomain/public_html/Sources/Subs-Members.php
Line: 974

i have that messages when i try create Primary Membergroups to Global Moderator and Aditional Membergroup done have access Administrator.

[Arantor]

When did this start happening?

[rednet]

done  already to fix it that error cz i have problem with my databse i have...

i think this happen becouse my databse SMF is UTF-8 characters and i dump some query with HTML entities..

anyway, thanks for you fastest respon 

[Arantor]

Do you have access to phpMyAdmin?

[rednet]

Do you have access to phpMyAdmin?

done to fix it bro  thanks you for fastest support you do

[Arantor]

Actually the problem is that some columns were being told to use UTF-8 rules for ordering their contents in a sort and some were being told use a different system and the two can't co-exist.

[rednet]

i have SMF with UTF-8 installed than i dump some query from my old databes with not UTF-8 character  i'm sorry for my fault, but anyway  thank's for information..