PDA

View Full Version : Import Language XML File error


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 : *****

UltimateOreo!
02-23-2007, 01:27 AM
Something is encoded with a different encoder. Suggested is utf8. Maybe even try re-writing the Porugese without the weird e?

jasbell
02-23-2007, 02:46 AM
It worked withoout the weird e, but I knew that would be the case. I wanted it (expected it) to workd with the weird e because the database is set to accept utf-8. What am I missing?

I gave up and wiped out everything. Started from zero

UltimateOreo!
04-13-2007, 11:25 PM
Well, if it helps at all anymore in the future, the database may not have accepted it as UTF8.