This is an old revision of the document!

Convert latin1 MySQL db to utf8

mysqldump -u username -p --add-drop-table database-name | replace CHARSET=latin1 CHARSET=utf8 | iconv -f latin1 -t utf8 | mysql -u username -p -D database-name

For websites, ensure that the header and document type are set correctly:

header('Content-Type: text/html; charset=UTF8');

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

php.ini should have:

; PHP's built-in default is text/html
default_mimetype = "text/html"
default_charset = "utf-8"