MySQL 5.5客户端字符集相关参数

柔情只为你懂 2024-04-18 00:46 35阅读 0赞

character\_set\_client 在客户端发出SQL语句所使用的字符集。  
  
 collation\_connection 连接所使用的字符集校对规则  
  
 character\_set\_results 返回到客户端的查询结果集（例如查询结果或错误信息）所使用的字符集  
  
 character\_set\_connection The character set used for literals that do not have a character set introducer and for number-to-string conversion  
  
**--指定客户端当前会话使用的字符集**  
  
 SET NAMES会同时更改character\_set\_client, character\_set\_connection,character\_set\_results这三个会话参数的字符集  
  
 mysql>  **set names utf8;**  
 Query OK, 0 rows affected (0.00 sec)  
  
 mysql> show variables like '%character%';  
 \+--------------------------+-----------------------+  
 | Variable\_name            | Value                 |  
 \+--------------------------+-----------------------+  
 | character\_set\_client     | utf8                  |  
 | character\_set\_connection | utf8                  |  
 | character\_set\_database   | gbk                   |  
 | character\_set\_filesystem | binary                |  
 | character\_set\_results    | utf8                  |  
 | character\_set\_server     | gbk                   |  
 | character\_set\_system     | utf8                  |  
 | character\_sets\_dir       | /data/share/charsets/ |  
 \+--------------------------+-----------------------+  
 8 rows in set (0.00 sec)  
  
 SET CHARACTER SET会更改character\_set\_client、character\_set\_results，同时将character\_set\_connection设置为character\_set\_database这个系统参数的值  
  
 mysql>  **set character set latin2;**  
 Query OK, 0 rows affected (0.01 sec)  
  
 mysql> show variables like '%character%';  
 \+--------------------------+-----------------------+  
 | Variable\_name            | Value                 |  
 \+--------------------------+-----------------------+  
 | character\_set\_client     | latin2                |  
 | character\_set\_connection | gbk                   |  
 | character\_set\_database   | gbk                   |  
 | character\_set\_filesystem | binary                |  
 | character\_set\_results    | latin2                |  
 | character\_set\_server     | gbk                   |  
 | character\_set\_system     | utf8                  |  
 | character\_sets\_dir       | /data/share/charsets/ |  
 \+--------------------------+-----------------------+  
 8 rows in set (0.00 sec)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-2077708/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-2077708/