MySQL 编码问题 ------------------------------------------------------------------------------- [引子] 修改数据库编码统一编码 [client] password=jlh2009 default-character-set=gbk [mysqld3310] default-character-set=gbk #deprecated init_connect='SET NAMES gbk' mysql> show variables like 'character_set_%'; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | gbk | | character_set_connection | gbk | | character_set_database | gbk | | character_set_filesystem | binary | | character_set_results | gbk | | character_set_server | gbk | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+ ------------------------------------------------------------------------------- [] http://dev.mysql.com/doc/refman/5.1/en/charset-configuration.html Character Set Configuration 1、You can change the default server character set and collation with the --character-set-server and --collation-server options when you start the server. 2、You can force client programs to use specific character set as follows: [client] default-character-set=charset_name http://dev.mysql.com/doc/refman/5.1/en/mysql-command-options.html#option_mysql_default-character-set 3、mysql Options --default-character-set=charset_name Use charset_name as the default character set for the client and connection. A common issue that can occur when the operating system uses utf8 or another multi-byte character set is that output from the mysql client is formatted incorrectly, due to the fact that the MySQL client uses the latin1 character set by default. You can usually fix such issues by using this option to force the client to use the system character set instead. http://dev.mysql.com/doc/refman/5.1/en/charset-connection.html 4、Connection Character Sets and Collations A SET NAMES 'x' statement is equivalent to these three statements: SET character_set_client = x; SET character_set_results = x; SET character_set_connection = x; http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_character-set-server Server Command Options 5、 --default-character-set=charset_name Command-Line Format --default-character-set=name -C name Option-File Format default-character-set=name Deprecated 5.0 Permitted Values Type string Use charset_name as the default character set. This option is deprecated in favor of --character-set-server. See Section 9.5, “Character Set Configuration”. --default-character-set is removed in MySQL 5.5. 6、 --character-set-server=charset_name, -C charset_name Command-Line Format --character-set-server Option-File Format character-set-server Option Sets Variable Yes, character_set_server Variable Name character_set_server Variable Scope Global, Session Dynamic Variable Yes Permitted Values Type string Use charset_name as the default server character set. See Section 9.5, “Character Set Configuration”. If you use this option to specify a nondefault character set, you should also use --collation-server to specify the collation. http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_init_connect 7、 init_connect Command-Line Format --init-connect=name Option-File Format init_connect Option Sets Variable Yes, init_connect Variable Name init_connect Variable Scope Global Dynamic Variable Yes Permitted Values Type string A string to be executed by the server for each client that connects. The string consists of one or more SQL statements, separated by semicolon characters. For example, each client session begins by default with autocommit mode enabled. There is no global autocommit system variable to specify that autocommit should be disabled by default, but init_connect can be used to achieve the same effect: ------------------------------------------------------------------------------- [结论] 修改数据库编码统一编码 [client] password=jlh2009 default-character-set=gbk [mysqld3310] character-set-server=gbk #需要测试 collation-server=gbk #需要测试 init_connect='SET NAMES gbk' ------------------------------------------------------------------------------- 参考地址: http://dev.mysql.com/doc/refman/5.1/en/charset-configuration.html http://dev.mysql.com/doc/refman/5.1/en/mysql-command-options.html#option_mysql_default-character-set http://dev.mysql.com/doc/refman/5.1/en/charset-connection.html http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_character-set-server http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_init_connect http://dev.mysql.com/doc/refman/5.1/zh/charset.html
