linux下mysql中文乱码

最新推荐文章于 2021-07-10 19:15:18 发布

原创最新推荐文章于 2021-07-10 19:15:18 发布 · 116 阅读

0 ·

CC 4.0 BY-SA版权

mysql 专栏收录该内容

10 篇文章

订阅专栏

本文详细介绍了如何在MySQL中设置字符集和校对规则，确保数据的正确存储和检索。通过一系列的SQL语句，演示了如何配置服务器、连接、数据库及结果集的字符集为UTF8，并设置相应的校对规则。

	set character_set_client = utf8;
    set character_set_server = utf8;
    set character_set_connection = utf8;
    set character_set_database = utf8;
    set character_set_results = utf8;
    set collation_connection = utf8_general_ci;
    set collation_database = utf8_general_ci;
    set collation_server = utf8_general_ci;