Switching a web site to UTF-8
From ShawnReevesWiki
I'd enjoy a web site that had zero issues with characters rendered improperly, so I'm considering converting my web sites to use the UTF-8 character set for storage and presentation.
Steps
- Convert all the existing data in every text field of every table in the database.
- Convert all the html pages to declare UTF-8 as their encoding.
- Convert all php scripts to use UTF-8 as the default character set.
- Convert all mysql connections and requests to use UTF-8.
Existing tutorials
- Converting a MySQL database to UTF-8
- http://www.drzycimski.com/programming/zend-framework/converting-a-mysql-database-to-utf-8/
- Converting Database Character Sets << WordPress Codex
- http://codex.wordpress.org/Converting_Database_Character_Sets