修改查看MYSQL字符集（charset）

本文主要是介绍修改查看MYSQL字符集（charset），希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

查看mysql的字符集

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.01sec)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.01 sec)

修改数据库的字符集

mysql>use databaseNamemysql>alter database databaseName character set utf-8;

在创建数据库时指定数据库的字符集

create database databaseName character set utf-8;create database databaseName default charset set utf8 collate utf8_general_ci;

mysql设置编码命令

SET character_set_client = utf8;
SET character_set_connection = utf8;
SET character_set_database = utf8;
SET character_set_results = utf8;
SET character_set_server = utf8;SET collation_connection = utf8_bin;
SET collation_database = utf8_bin;
SET collation_server = utf8_bin;

这篇关于修改查看MYSQL字符集（charset）的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---