• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
I get an error when processing data in different languages

#1
[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:
Quote: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.

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

And let me know whether it helps .. good luck

#3
[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";


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.