MySQL 查看编码 排序规则

概述查看数据库的排序规则mysql> show variables like 'collation%';+----------------------+-------------------+| Variable_name | Value |+----------------------+-------------------+| collation_connection | utf8_general_ci || collation_database | utf8_general_ci || collation_server | latin1_swedish_ci |+----------------------+-------------------+3 rows in set (0.00 sec)查看数据库的编码格式mysql> show variables like 'char%';+--------------------------+----------------------------+| 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 | latin1 || character_set_system | utf8 || character_sets_dir | /usr/share/mysql/charsets/ |+--------------------------+----------------------------+8 rows in set (0.00 sec)查看字段的排序规则mysql> show create table tablename;查看表字段信息mysql> desc tablename;查看当前数据库编码mysql> use databasename;Database changedmysql> show variables like 'character_set_database';+------------------------+-------+| Variable_name | Value |+------------------------+-------+| character_set_database | utf8 |+------------------------+-------+1 row in set (0.03 sec)修改当前数据库的编码mysql> use databasename;Database changedmysql> alter database databasename character set latin1; #将之前的utf8编码修改为latin1编码Query OK, 1 row affected (0.00 sec)+------------------------+--------+| Variable_name | Value |+------------------------+--------+| character_set_database | latin1 |+------------------------+--------+1 row in set (0.00 sec)查看字段编码SHOW FULL COLUMNS FROM tablename;修改字段的字符集ALTER TABLE tablename CHANGE c_name c_name CHARACTER SET character_name [COLLATE ...];如：ALTER TABLE users CHANGE title title VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci; 

查看title="MysqL知识库" href="http://lib.csdn.net/base/MysqL" target="_blank">数据库的排序规则

MysqL show variables Variable_name Value collation_connection utf8_general_ci collation_database utf8_general_ci collation_server latin1_swedish_ci rows ( sec)

查看数据库的编码格式

MysqL show variables Variable_name Value character_set_clIEnt utf8 character_set_connection utf8 character_set_database utf8 character_set_filesystem character_set_results utf8 character_set_server latin1 character_set_system utf8 character_sets_dir usrshareMysqLcharsets rows ( sec)

查看字段的排序规则

MysqL show tablename;

查看表字段信息

MysqL tablename;

查看当前数据库编码

MysqL MysqL<span >> show variables <span >like <span >'<span >character_set_database<span >'<span >;
<span >+<span >--<span >----------------------+-------+
<span >| Variable_name <span >| Value <span >|
<span >+<span >--<span >----------------------+-------+
<span >| character_set_database <span >| utf8 <span >|
<span >+<span >--<span >----------------------+-------+
<span >1 row <span >in <span >set (<span >0.03 sec)

修改当前数据库的编码

MysqL MysqL<span >> <span >alter <span >database databasename <span >character <span >set<span > latin1; #将之前的utf8编码修改为latin1编码
query OK,<span >1 row affected (<span >0.00<span > sec)
<span >+<span >--<span >----------------------+--------+
<span >| Variable_name <span >| Value <span >|
<span >+<span >--<span >----------------------+--------+
<span >| character_set_database <span >| latin1 <span >|
<span >+<span >--<span >----------------------+--------+
<span >1 row <span >in <span >set (<span >0.00 sec)

查看字段编码

SHOW ColUMNS tablename;

修改字段的字符集

tablename CHANGE c_name c_name character_name users CHANGE Title Title () utf8 ColLATE utf8_general_ci;

 

总结

以上是内存溢出为你收集整理的MySQL 查看编码 排序规则全部内容，希望文章能够帮你解决MySQL 查看编码 排序规则所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。

欢迎分享，转载请注明来源：内存溢出

原文地址: https://outofmemory.cn/sjk/1169078.html