SMF Support > SMF 2.0.x Support

Illegal mix of collations ... Problem

(1/3) > >>

hackrishna:
Using SMF 2.0.2. Error Message i'm getting is

Database Error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation 'like'
File: /home/epicmaga/public_html/tech/Sources/ManageBans.php
Line: 1710

All the tables are of UTF8_unicode, which table i need to change the collation at phpmyAdmin for fixing this Error...

Thank you in advance  :)


hackrishna:
Anybody :(

Oldiesmann:
You need to change the collation of the email_address column in the members table to utf8_unicode_ci since that's what all your other tables are.

ziycon:

--- Quote from: hackrishna on April 01, 2012, 05:07:21 AM ---Using SMF 2.0.2. Error Message i'm getting is

Database Error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation 'like'
File: /home/epicmaga/public_html/tech/Sources/ManageBans.php
Line: 1710

All the tables are of UTF8_unicode, which table i need to change the collation at phpmyAdmin for fixing this Error...

Thank you in advance  :)

--- End quote ---
This isn't an issue with the table collation its regarding a mismatch between two fields, for the 'LIKE' statement to work both fields being used need to be of the same collation. check the collation for what Oldiesmann said, if it doesn't solve your issue let us know.

hackrishna:

--- Quote from: Oldiesmann on April 02, 2012, 12:12:52 AM ---You need to change the collation of the email_address column in the members table to utf8_unicode_ci since that's what all your other tables are.

--- End quote ---

How to change it ?? The column of email_address in members table.... I coudn't select it all together and change the collation :(

Navigation

[0] Message Index

[#] Next page

Go to full version