ÍêÃÀ½â¾ömysqlÏÂutf 8µÄÂÒÂëÎÊÌâ

ÍêÃÀ½â¾ömysqlÏÂutf-8µÄÂÒÂëÎÊÌâ
½¨±íʱÏȼÓÉÏdefault charset=utf8;
²åÈëÖÐÎÄÊý¾Ý֮ǰ(MysqlÃüÁîÌáʾ·ûÏÂ)ÊÇÓÃset names gb2312;
ÔÚphpÒ³ÃæÖÐÉèÖÃÊÇmysql_query('SET NAMES UTF8');
ÔÚphpÒ³Ãæ(ÒÑÉ趨Ϊutf8ºó)ÖвåÈëÖÐÎÄÊý¾Ý²»»á³öÏÖÂÒÂë,Ó¦¸Ã²åÈëÊý¾Ý¿âµÄʱºò¾ÍÊÇÒÔutf8×Ö·û¼¯²åÈëÖÐÎÄÊý¾ÝµÄ¹Ê²»»á³öÏÖÎÊÌâ!
ÔÚphpÒ³ÃæÇ°Ãæ²»ÒªÍüÁ˼ÓÉÏheader('content-type;text/html;charset=utf-8');
´ó¼ÒÔÚMySQLÃüÁîÌáʾ·ûÏÂÏë²é¿´Êý¾Ý,ÖÐÎÄÊý¾ÝÓпÉÄÜÊÇÈçÏ '?????'
ËùÒÔ´ó¼ÒÏë²é¿´µ½ÕýÈ·µÄÖÐÎÄÒªÓë²åÈëÖÐÎÄÊý¾ÝÒ»ÑùʹÓÃset names gb2312;
Àý×Ó:
CREATE DATABASE mydb;
USE mydb5;
CREATE TABLE news
(
      news_id int not null auto_increment,
      news_title varchar(100) not null,
      news_contents text not null,
      news_date datetime not null,
      primary key(news_id)
)default charset=utf8;
set names gb2312;  
INSERT INTO news VALUES(null, 'ÐÂÎÅ1', '111111', now());
INSERT INTO news VALUES(null, 'ÐÂÎÅ2', '222222', now());
INSERT INTO news VALUES(null, 'ÐÂÎÅ3', '333333', now());
INSERT INTO news VALUES(null, 'ÐÂÎÅ4', '444444', now());
INSERT INTO news VALUES(null, 'ÐÂÎÅ5', '555555', now());
Microsoft Windows XP [°æ±¾ 5.1.2600]
(C) °æȨËùÓÐ 1985-2001 Microsoft Corp.
C:\Documents and Settings\YSDH.YSDH-0>cd \
C:\>mysql -h localhost -uroot -p
Enter password: ******
Welcome to the MySQL monitor.                          Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 5.0.22-community-nt-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use mydb;
Database changed
mysql> INSERT INTO vote VALUES(null,'ÄãÊÇ´ÓÄÄÀïÁ˽⵽±¾Õ¾µÄ?',1,default);
Query OK, 1 row affected (0.00 sec)
mysql> set names utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INTO vote VALUES(null,'ÄãÊÇ´ÓÄÄÀïÁ˽⵽±¾Õ¾µÄ?',1,default);
ERROR 1406 (22001): Data too long for col