mysql中文显示问题，高手帮忙看看阿！

Question

你用\s看看mysql是什么语言环境啊？
http://www.uudangdang.com

Answer 1

mysql> \s
--------------
mysql  Ver 14.3 Distrib 5.0.0-alpha, for Win95/Win98 (i32)Connection id:          5
Current database:       data1
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.0.0-alpha-nt
Protocol version:       10
Connection:             localhost via TCP/IP
Client characterset:    latin1_swedish_ci
Server characterset:    latin1_swedish_ci
TCP port:               3306
Uptime:                 15 min 33 secThreads: 2  Questions: 214  Slow queries: 0  Opens: 7  Flush tables: 1  Open tab
les: 1  Queries per second avg: 0.229
--------------
帮我看看怎么弄，麻烦你了，谢谢！

Answer 2

Server characterset:    latin1_swedish_ci
改成Server characterset:    gb2312
创建数据库的时候用
CREATE DATABASE `mydatabase` DEFAULT CHARACTER SET gb2312 COLLATE gb2312_chinese_ci;