+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: I get an error when processing data in different languages (/showthread.php?tid=9086)
I get an error when processing data in different languages - El Forum - 06-11-2008
[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.
I get an error when processing data in different languages - El Forum - 06-12-2008
[eluser]Nikhil Vijayan[/eluser]
change the collation type of column to ascii_bin
And let me know whether it helps .. good luck
I get an error when processing data in different languages - El Forum - 02-26-2010
[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";Code:
$db[...]['char_set'] = "utf8";
$db[...]['dbcollat'] = "utf8_unicode_ci";