http://wenku.baidu.com/link?url=W3_QMZQrAlPh73WBb_IC7Qf1BrSHlrYIaNIeUJ6VhUv_2lzr1vX94vfilheRBK41mq9MZBJswG0ugCEezAM0WE8RiR6TVDMzOtNaDGZ6Rhm

mysql命令行修改字符编码
1、修改数据库字符编码

mysql> alter database mydb character set utf8 ;

2、创建数据库时，指定数据库的字符编码

mysql> create database mydb character set utf8 ;

3、查看mysql数据库的字符编码

mysql> show variables like 'character%'; //查询当前mysql数据库的所有属性的字符编码

+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | latin1                     |
| character_set_connection | latin1                     |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | latin1                     |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

4、修改mysql数据库的字符编码

mysql> set character_set_client=utf8 ;

mysql> set character_set_connection=utf8 ;

mysql> set character_set_database=utf8 ;

mysql> set character_set_database=utf8 ;

mysql> set character_set_results=utf8 ;

mysql> set character_set_server=utf8 ;

mysql> set character_set_system=utf8 ;

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)

分类: 数据库专栏
标签: mysql命令行创建数据库, 修改mysql数据库的字符编码, 修改mysql数据库的系统字符编码


MySQL 命令行下 字符集设置 2008-07-13 12:08:23
分类： Mysql/postgreSQL


MySQL 命令行下 字符集设置
在命令行工具mysql下，操作数据库时要保证编码的一致。
这里所说的编码是指数据库编码，连接编码，客户端编码。
可以通过命令 show variables like 'character_set_%';来查询


 
 
 mysql> show variables like 'character_set_%';
+--------------------------+----------------------------------------+
| Variable_name            | Value                                  |
+--------------------------+----------------------------------------+
| character_set_client     | latin1                                 |
| character_set_connection | latin1                                 |
| character_set_database   | latin1                                 |
| character_set_filesystem | binary                                 |
| character_set_results    | latin1                                 |
| character_set_server     | latin1                                 |
| character_set_system     | utf8                                   |
| character_sets_dir       | C:mysql-5.0.51b-win32sharecharsets |
+--------------------------+----------------------------------------+
8 rows in set (0.00 sec)
 

Latin1是瑞典编码，
如果要更改编码，使用下面的命令：set character_set_client=utf8;
 mysql> set character_set_client=utf8;
 Query OK, 0 rows affected (0.00 sec)

 mysql> set character_set_connection=utf8;
 Query OK, 0 rows affected (0.00 sec)






只要你的三个编码 character_set_client character_set_connectio character_set_database保持一致，在命令行工具下，操作就不会出现乱码问题。