MySql 修改编码以及字符集

最新推荐文章于 2023-08-13 21:30:16 发布

原创最新推荐文章于 2023-08-13 21:30:16 发布 · 112 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #网络

Mysql 专栏收录该内容

4 篇文章

订阅专栏

本文介绍如何在MySQL的my.ini配置文件中设置字符集和编码，包括客户端和服务器端的配置选项，帮助用户正确地配置MySQL以支持不同语言的字符。

进入数据库的安装目录：C:/Program Files/MySQL/MySQL Server 5.0

里面有一个my.ini文件找到这个位置

CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]

port=3306

[mysql]

default-character-set=utf8

# ----------------------------------------------------------------------

在这段，你可以修改数据库使用的字符集

***************************************************************************

[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306

#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/MySQL Server 5.0/"

#Path to the database root
datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"

# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=utf8

# ----------------------------------------------------------------------