Migrating from ISO charset to UTF-8

[eluser]bonatoc[/eluser]
Here some links one may find useful.

I personally set the default charset as :

Encoding : UTF-8 Unicode (utf8)
Collation : utf8_general_ci

This may be of interest :
http://philsturgeon.co.uk/news/2009/08/U...odeIgniter

If you're migrating from already populated tables using a different encoding (ISO-8859 or other), you may have to do some cleaning by building your own loop PHP scripts using utf8_encode and such, for updating columns containing text, or trying this :

http://paulkortman.com/2009/07/24/mysql-...onversion/

With a dedicated server, you may as well declare your specific site via htaccess : this allows you to keep sites using other encodings on the same webserver untouched :

http://www.askapache.com/htaccess/settin...ccess.html

Even after all that, some existing data coming from the DB may still need some tweaking using utf8_encode and/or other php functions such as html_entity_decode, etc... Newly inserted data should be okay.