Encoding problem and MySQL
When trying to move a WordPress blog from one machine (mine) to another (a provider) by dumping the local tables with PhpMyAdmin and loading them with the remote PhpMyAdmin, I noticed a corruption of all unicode caracters (the blog is in French). Looking at the contents of both MySQL bases (the wp_posts table, eg), I noticed they were encoded differently, and while they display correctly in WP on the source machine, it’s not the case on the destination.
Both WP installations are configured with UTF-8 encoding.
I also notice something weird on the local (OK) blog; a character like Ã¢ (a circumflex) which, in unicode, is <E2>, and should thus be in UTF-8 <C3><A2> (unless I am wrong), is represented in the MySQL table as <C3><83><C2><A2>, which baffles me no end (and probably PhpMyAdmin too). I don’t know what this encoding is, why it is not UTF-8 and then why it shows correctly in the blog…
Help would be appreciated. Thanks in advance,
- The topic ‘Encoding problem and MySQL’ is closed to new replies.