character_set_client等的字符集设置

RogerZhuo

@冷月汉宫秋
mysql命令登录机的/etc/my.cnf中[mysql]下配置。

yulihua49

冷月汉宫秋 发表于 2013-8-1 16:44
额。。那个2）我看到了，可是我在[client]里已经加了default-character-set=utf8后，用root登录进去，是不 ...

这是我们的：/etc/my.cnf:
[mysqld]
ndbcluster
datadir=/home/mysqlc/my_cluster/mysqld_data
basedir=/home/mysqlc/mysqlc
character_set_server=gbk
port=5000

[client]
default-character-set = gbk

[mysql]
default-character-set = gbk

冷月汉宫秋

yulihua49 发表于 2013-8-9 14:36
这是我们的：/etc/my.cnf:
[mysqld]
ndbcluster

好的,谢谢各位啦~~我已经找到解决方法了，非常感谢各位的帮忙！

jinguanding

冷月汉宫秋 发表于 2013-8-1 16:44
额。。那个2）我看到了，可是我在[client]里已经加了default-character-set=utf8后，用root登录进去，是不 ...

问题：不允许重新启动的生产环境出现字符集设置不对，如何从默认的latin1修改为utf8

生产环境正确做法和步骤：

1.在配置文件my.cnf中 [client] 增加 default-character-set =utf8 ,会立即对本机上的新创建连接生效

2.在配置文件my.cnf中 [mysqld] 增加 default-character-set =utf8 ，待mysqld服务重新启动后生效

3. 执行SET语句修改字符集，对非本机新创建的连接也会生效

SET GLOBAL character_set_clinet=utf8;
SET GLOBAL character_set_connection=utf8;
SET GLOBAL character_set_database=utf8;
SET GLOBAL character_set_results=utf8;
SET GLOBAL character_set_server=utf8;

4.对于之前的连接线程，则没有办法，除非他们自己设置为utf8 或者等待其断开重新连接


www.hotpu.cn

lzd_7993

1、修改配置文件:default-character-set=utf8;
2、set global character -set-connctions=utf8;
     set global character-set -server=utf8;
     set global character- set-client=utf8;
     set global character-set-database=utf8;
   

WGY20051896

jinguanding 发表于 2013-8-14 13:07
问题：不允许重新启动的生产环境出现字符集设置不对，如何从默认的latin1修改为utf8

生产环境正确做法 ...

这个是对于默认的latin1到utf8 有效。 如果客户那边显式设置gbk，应该可以把server端设置的给修改掉吧。求问

WGY20051896

jinguanding 发表于 2013-8-14 13:07
问题：不允许重新启动的生产环境出现字符集设置不对，如何从默认的latin1修改为utf8

生产环境正确做法 ...

Hi，
    我查了下如果client那边没有显示指定的话，还会是默认的，比如latin1。 具体描述可以看下面

http://bugs.mysql.com/bug.php?id=35372


Updated the description for character_set_client:

The character set for statements that arrive from the client. The
session value of this variable is set using the character set
requested by the client when the client connects to the server. (Many
clients support a --default-character-set option to enable this
character set to be specified explicitly.) The global
value of the variable is used to set the session value in cases when
the client-requested value is unknown or not available, or the server
is configured to ignore client requests:

* The client is from a version of MySQL older than MySQL 4.1, and thus
does not request a character set.

* The client requests a character set not known to the server. For
example, a Japanese-enabled client requests sjis when connecting to a
server not configured with sjis support.

* mysqld was started with the --skip-character-set-client-handshake
option, which causes it to ignore client character set configuration.
This reproduces MySQL 4.0 behavior and is useful should you wish to
upgrade the server without upgrading all the clients.

所以光是从server这边去设置是没有效果的。