mysql 乱码 utf8

 

my.ini

[mysql]
default-character-set=utf8

 

 

[mysqld]
character-set-server=utf8

 

show variables like '%char%'; 

mysql建表

CREATE TABLE `xxx ` (myname varchar(255)) ENGINE=MyISAM DEFAULT CHARSET=utf8

 

mysql_query('set names utf8');//utf8 gb2312

 

Alter DATABASE 'test' DEFAULT CHARACTER SET utf8 COLLATE utf8_bi

set character_set_database=utf8; 

set character_set_server=utf8;  

 

 

set names 'utf8';

相当于下面4句话

set character_set_client = utf8;
set character_set_results = utf8;
set character_set_connection = utf8;
set collation_connection = utf8_general_ci