I get an error when processing data in different languages

[eluser]KeyStroke[/eluser]
Hi,

I have a login form for a multi-lingual site that doesn't seem to accept input in multiple languages.

For example, when a user enters his login name in Arabic, this error message will show up:

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

What can I do to fix this problem? it's obviously something in my database, but I have no idea what's wrong.

Appreciate your help.

[eluser]Nikhil Vijayan[/eluser]
change the collation type of column to ascii_bin

And let me know whether it helps .. good luck

[eluser]Unknown[/eluser]
If you want to use UTF-8 for your database (which I recommend) it`s NOT sufficient to set the database and table charset to UTF-8. You also need to set the charset for each field.

Also, in your database config file you should change

Code:

$db[...]['char_set'] = "latin1";
$db[...]['dbcollat'] = "latin1_swedish_ci";

to

Code:

$db[...]['char_set'] = "utf8";
$db[...]['dbcollat'] = "utf8_unicode_ci";