jasbell
02-23-2007, 01:06 AM
When I went to import a Portuguese language xml file I entered "Portugu?se" in the field named "Title for Uploaded Language" and got the below database error. This concerns me because I know that I configured MySQLI OPTIONS in the config.php with the line:
$config['Mysqli']['charset'] = 'utf8';
Below is the error, and I just want to know what this means, and why I could not insert a UTF-8 compliant word.
Database error in vBulletin 3.6.4:
Invalid SQL:
SELECT languageid FROM language WHERE title = 'Portugu?se';
MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Error Number : 1267
Date : Thursday, February 22nd 2007 @ 08:53:36 PM
Script : http://www.mysite.com/forums/admincp/language.php?do=upload
Referrer : http://www.mysite.com/forums/admincp/language.php?do=files
IP Address : **.***.***.**
Username : *****
Classname : *****
$config['Mysqli']['charset'] = 'utf8';
Below is the error, and I just want to know what this means, and why I could not insert a UTF-8 compliant word.
Database error in vBulletin 3.6.4:
Invalid SQL:
SELECT languageid FROM language WHERE title = 'Portugu?se';
MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Error Number : 1267
Date : Thursday, February 22nd 2007 @ 08:53:36 PM
Script : http://www.mysite.com/forums/admincp/language.php?do=upload
Referrer : http://www.mysite.com/forums/admincp/language.php?do=files
IP Address : **.***.***.**
Username : *****
Classname : *****