24/7 U.S. Support – 877-595-4482
2012-02-20 4:26 pm
I'm sorry you're having trouble with character encoding on your site. This is usually due to the collation of your tables in the MySQL database. If you changed the character set of the database after importing your data, please note that changing the collation after importing data does not make any changes to that data. It only sets the collation for new tables and data in that database. You will either want to recreate your database and change the collation before importing your data or use the script shown in our article on how to Convert a Database to convert the data you already imported into that database.
Please note, UTF-8 is a standard collation that should work for most languages. If your data needs a different character set, you can also modify that script to to convert to a different character set by editing the following lines with the correct character set:
$sql = "ALTER TABLE $table DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci";
print "$table changed to UTF-8 successfully.\n";
Please let us know if you have any additional questions or need further assistance.
|Email:||support@WebHostingHub.com||Ticket:||Submit a Support Ticket|
|Chat:||Click To Chat Now|