mysql中的数据编码
来源:百度文库 编辑:神马文学网 时间:2024/06/03 10:36:46
mysql 4.1版本后,对编码的支持大大加强,这是它自己的说法:
MySQL 4.1 can do these things for you:
Store strings using a variety of character sets
Compare strings using a variety of collations
Mix strings with different character sets or collations in the same server, the same database, or even the same table
Allow specification of character set and collation at any level
In these respects, not only is MySQL 4.1 far more flexible than MySQL 4.0, it also is far ahead of other DBMSs
见:http://dev.mysql.com/doc/mysql/en/charset-general.html
1 character set和collation的区别
character set表示字符集,也就是字符(character)和对应的编码(encoding)合称为character set.
collation是字符间比较的方法,比如binaray, case sensitive, case insensitive。
2 character set, collation的设置
可以通过show variables like "%char"; show variables like "%collation%"分别查看当前的设置情况。
在my.cnf文件中,可以使用:
character-set-server=utf8
collation-server-utf8
设置缺省server的character set, collation,这两个选项从4.1.3版本开始有效。之前版本的设置方法:
default-character-set=utf8
default-collation=utf8
通过上面的设置后,show variables like "%char%"如下所示:
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_results | latin1 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
show variables like "%collation%"显示:
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-------------------+
3 问题
我希望character-set-client, character-set-results,character-set-connection也是utf8, collation-connection也是utf8_general_ci,不知道在my.cnf中如何设置才能做到?
我目前都是先执行set names 'utf8',再作进一步查询。
执行set names 'utf8'后,show variables "%char%", show variables "%collation%"显示所有的变量设置都是utf8的了。
MySQL 4.1 can do these things for you:
Store strings using a variety of character sets
Compare strings using a variety of collations
Mix strings with different character sets or collations in the same server, the same database, or even the same table
Allow specification of character set and collation at any level
In these respects, not only is MySQL 4.1 far more flexible than MySQL 4.0, it also is far ahead of other DBMSs
见:http://dev.mysql.com/doc/mysql/en/charset-general.html
1 character set和collation的区别
character set表示字符集,也就是字符(character)和对应的编码(encoding)合称为character set.
collation是字符间比较的方法,比如binaray, case sensitive, case insensitive。
2 character set, collation的设置
可以通过show variables like "%char"; show variables like "%collation%"分别查看当前的设置情况。
在my.cnf文件中,可以使用:
character-set-server=utf8
collation-server-utf8
设置缺省server的character set, collation,这两个选项从4.1.3版本开始有效。之前版本的设置方法:
default-character-set=utf8
default-collation=utf8
通过上面的设置后,show variables like "%char%"如下所示:
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_results | latin1 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
show variables like "%collation%"显示:
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-------------------+
3 问题
我希望character-set-client, character-set-results,character-set-connection也是utf8, collation-connection也是utf8_general_ci,不知道在my.cnf中如何设置才能做到?
我目前都是先执行set names 'utf8',再作进一步查询。
执行set names 'utf8'后,show variables "%char%", show variables "%collation%"显示所有的变量设置都是utf8的了。
mysql中的数据编码
删除mysql数据库中的重复数据记录_MySQL_网贝建站
MySQL数据导入导出
如何修改MYSQL的默认编码
修改mysql字符编码成为UTF8
如何修改MYSQL的默认编码
修改mysql字符编码成为UTF8
数字数据的数字信号编码
MYSQL数据同步备份复制
MySQL数据导入与导出
java中的编码问题
两种设置MYSQL查询编码的PHP语句
MYSQL的master/slave数据同步配置
MySQL数据导入导出工具mysqlimport简介
将sqlserver的数据导入Mysql中
MySQL实现表中取出随机数据
MYSQL的master/slave数据同步配置
MySQL是如何随机选取数据的
人生中的重要数据
电子商务中的数据挖掘
人生中的重要数据
如何实现MySQL中的用户管理
MySQL中的mysqldump命令使用详解
Linux下MySQL客户端mysql,select大量数据时可以分页