mysql的字符编码_JAVA_编程开发_程序员俱乐部

中国优秀的程序员网站程序员频道CXYCLUB技术地图
热搜:
更多>>
 
您所在的位置: 程序员俱乐部 > 编程开发 > JAVA > mysql的字符编码

mysql的字符编码

 2011/11/21 7:54:49  huangyunbin  http://huangyunbin.iteye.com  我要评论(0)
  • 摘要:首先要修改my.ini的default-character-set和character-set-serve为自己想要的字符编码character_set_server:这是设置服务器使用的字符集character_set_database:这是设置数据库使用的字符集character_set_client:这是设置客户端发送Query串使用的字符集character_set_connection:这是设置服务器需要将收到的查询串转换成的字符集character_set_results
  • 标签:SQL MySQL

首先要修改my.ini的 default-character-set和character-set-serve为自己想要的字符编码

character_set_server:这是设置服务器使用的字符集
     character_set_database:这是设置数据库使用的字符集
      character_set_client :这是设置客户端发送Query串使用的字符集
      character_set_connection :这是设置服务器需要将收到的查询串转换成的字符集
      character_set_results :这是设置服务器要将结果数据转换到的字符集,转换后才发送给客户端
上面的是改整个数据库的,注意每张表还有自己的字符集。没弄对的话还是会报1366错误


通过MySQL命令行修改:

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)

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

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

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

mysql> set character_set_system=utf8;
Query OK, 0 rows affected (0.01 sec)

mysql> set collation_connection=utf8;
Query OK, 0 rows affected (0.01 sec)

mysql> set collation_database=utf8;
Query OK, 0 rows affected (0.01 sec)

mysql> set collation_server=utf8;
Query OK, 0 rows affected (0.01 sec)


查看:
mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
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.03 sec)

mysql> show variables like 'collation_%';
+----------------------+-----------------+
Variable_name        Value         
+----------------------+-----------------+
collation_connection utf8_general_ci
collation_database   utf8_general_ci
collation_server     utf8_general_ci
+----------------------+-----------------+
3 rows in set (0.04 sec)

-------------------------------------------------------------------------
发表评论
用户名: 匿名