Originally Posted by
lat9
Check out
Convert db2utf8, with a database that old, I'm guessing that you've either got "mixed database collations" or the 'collation' (aka language) used by the database is different from the value identified by your /admin/includes/configure.php and /includes/configure.php files' DB_CHARSET setting.
Thanks!
My configure.php has:
define('DB_CHARSET', 'utf8'); // 'utf8' or 'latin1' are most common
While using phpMyAdmin to look at the database shows:
Collation: latin1_swedish_ci
...which it turns out is the default setting for databases in earlier versions of mySQL, I guess.
I'm a little worried about this comment in the Convert db2utf8 link:
CAUTION: If your database is NOT in UTF8 format but contains UTF8 characters, you may end up with unpredictable results. ALWAYS MAKE A DATABASE BACKUP FIRST!!!!
I have had people use UTF8 characters in registrations; I hope it doesn't blow up.... I will backup the database of course.
Bookmarks