http://dev.mysql.com/doc/refman/5.0/en/charset-applications.html
http://www.bluebox.net/news/2009/07/mysql_encoding
http://yoonkit.blogspot.com/2006/03/mysql-charset-from-latin1-to-utf8.html
http://www.bluebox.net/news/2009/07/mysql_encoding
http://yoonkit.blogspot.com/2006/03/mysql-charset-from-latin1-to-utf8.html
MySql Character Set
If you want to get UTF-8 data back from a mysql databases you will need to change the default character set for your mysql client from latin1 to utf8
changing client character set to utf-8
default-character-set=utf8
or mysql command
mysql> SET NAMES 'utf8'
or in php code
$mysqli->set_charset("utf8");verify client character set is utf-8
connect to mysql and vefify your clients character setmysql> show variables like 'char%'; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+ 8 rows in set (0.01 sec)
REFERRERS
MySql
