mysqlÂÒÂëÎÊÌâ

ÎÒÔÚubuntuÏ´îÅäÀïphp»·¾³£¬¿ÉÊÇÀïÃæµÄ±àÂëÎÊÌâ¿ì°ÑÎұƷèÁË¡£
Ï£Íû¸ßÊÖÄÜ°ïÎÒ½â¾ö¡£Ð»ÁË¡£¡£¡£

ÎÒµÄmysql×Ö·ûÉèÖÃÈçÏ£º

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)

µ±ÎÒÒªÔÚSQLÓï¾äÖвåÈëÖÐÎÄʱ£¬È«±ä³ÉÎʺÅÁË¡£

mysql> insert into dt_test2(name,password)
  -> values('������','123456');

Èç¹ûÖ´Ðвéѯºó£¬ÏÔʾµÄ½á¹û¼¯»¹ËùÖÐÎÄ¡£

mysql> select * from dt_test2;
+-----------------+----------+
| name | password |
+-----------------+----------+
| Ò£Ô¶µÄ¼ÇÒä | 123456 | 
| Ò£Ô¶ |