Switching a web site to UTF-8: Difference between revisions

From ShawnReevesWiki
Jump to navigationJump to search
Created page with "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 presen..."
 
Line 7: Line 7:
#Convert all mysql connections and requests to use UTF-8.
#Convert all mysql connections and requests to use UTF-8.
===Existing tutorials===
===Existing tutorials===
http://www.drzycimski.com/programming/zend-framework/converting-a-mysql-database-to-utf-8/
;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


[[Category:internet]]
[[Category:internet]]

Revision as of 11:01, 16 April 2013

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

  1. Convert all the existing data in every text field of every table in the database.
  2. Convert all the html pages to declare UTF-8 as their encoding.
  3. Convert all php scripts to use UTF-8 as the default character set.
  4. 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