mysql 解决中文乱码问题

版本：mysql-5.0.67-win32

 

my-medium.ini 复制后改名 my.ini，添加 default-character-set=utf8

 

# The following options will be passed to all MySQL clients

[client]

#password= your_password

port= 3306

socket= /tmp/mysql.sock

default-character-set=utf8

# Here follows entries for some specific programs

 

# The MySQL server

[mysqld]

port= 3306

socket= /tmp/mysql.sock

skip-locking

key_buffer = 16M

max_allowed_packet = 1M

table_cache = 64

sort_buffer_size = 512K

net_buffer_length = 8K

read_buffer_size = 256K

read_rnd_buffer_size = 512K

myisam_sort_buffer_size = 8M

default-character-set=utf8

 

重启后查看：show variables like 'character%';

 

如不是 utf-8，删除重新建数据库和表。