Friday, August 03, 2012

MySQL UTF8 setting for PHP and MySQL Connection

Ref.http://www.vixual.net/blog/archives/310
Ref.http://blog.cmchen.net/2007/12/17/2498/

/etc/my.cnf

[mysql]
default-character-set=utf8

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
default-character-set=utf8

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid



mysql> show variables like 'character%';
+--------------------------+----------------------------+
| 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.00 sec)

mysql>

=======================================================

<?php
        //----------------mysql utf8----------------

        mb_internal_encoding('utf8');
        mysql_query("SET CHARACTER SET 'utf8'");






        mysql_query("SET NAMES 'UTF8;'");
        mysql_query("SET CHARACTER_SET_CLIENT=UTF8;");
        mysql_query("SET CHARACTER_SET_RESULTS=UTF8;");
        //----------------mysql utf8----------------
?>

1 comment: