Most of us have had problems with UTF-8 problems in PHP and MySQL. Here’s how to modify your database and table to be UTF-8 compliant. Most of the time we do set the character set to utf8 but forget to set the collation set to utf8.
Use the following MySQL statements to convert your database and tables:
ALTER DATABASE mydatabase
CHARACTER SET utf8
DEFAULT CHARACTER SET utf8
COLLATE utf8_general_ci
DEFAULT COLLATE utf8_general_ci ;
ALTER TABLE mytable
DEFAULT CHARACTER SET utf8
COLLATE utf8_general_ci ;
PHPDeveloper.org on December 28, 2006
Vinu Thomas’ Blog: Modifying your MySQL databases to be UTF-8 compliant…
…
Zend_Db: utf8 query string gets inserted as non-utf8 « Willing wheels on June 28, 2009
[...] http://blogs.vinuthomas.com/2006/12/22/modifying-your-mysql-databases-to-be-utf-8-compliant/ [...]