MySQL字符集设定全部参数为UTF8的代码示例

时间:2025-11-02 17:32:19来源:极客码头作者:域名
MySQL字符集设定全部参数为UTF8的代码示例
符集复制MySQL(和PHP搭配之最佳组合)> SHOW VARIABLES LIKE collation_%;   +----------------------+-------------------+   | Variable_name | Value |   +----------------------+-------------------+   | collation_connection | latin1_swedish_ci |   | collation_database | utf8_general_ci |   | collation_server | utf8_general_ci |   +----------------------+-------------------+   3 rows in set (0.00 sec)   MySQL(和PHP搭配之最佳组合)> SHOW VARIABLES LIKE character_set_%;   +--------------------------+------------------------------------------------+   | 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 | D:\data\MySQL(和PHP搭配之最佳组合)\MySQL(和PHP搭配之最佳组合) Server 4.1\share\charsets/ |   +--------------------------+------------------------------------------------+   7 rows in set (0.00 sec)   1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.
相关内容