Posted by Willem Bogaerts on 04/24/07 09:18

> 1. Use phpMyAdmin to make sure your MySQL connection encoding is also UTF-8

When connecting to MySQL 5+, the default client encoding is taken to be
latin-1, even if you set it to utf-8 in the config file ([mysql]
section). You will have to issue a "SET NAMES utf8" command after
connecting, otherwise MySQL will RE-encode from latin-1 to utf-8!

If you want to see what encoding really is stored in the database (and
if the data is re-encoded), use the mysqldump utility.

Best regards,
--
Willem Bogaerts

Application smith
Kratz B.V.
http://www.kratz.nl/

[Back to original message]