标题: mysql 8.0设置collation_connection [打印本页] 作者: 光之使者 时间: 2022-9-28 22:30 标题: mysql 8.0设置collation_connection 设置全局
set global collation_connection = utf8mb4_general_ci
设置会话级别
1.配置文件方式,给每个新的连接配置
[mysqld]
init-connect='SET NAMES utf8mb4 COLLATE utf8mb4_general_ci '
2.执行命令
set collation_connection = utf8mb4_general_ci
或
SET NAMES utf8mb4 COLLATE utf8mb4_general_ci
附录：
SQL Statements for Connection Character Set Configuration
After a connection has been established, clients can change the character set and collation system variables for the current session. These variables can be changed individually using SET statements, but two more convenient statements affect the connection-related character set sytem variables as a group:
SET NAMES 'charset_name' [COLLATE 'collation_name'] SET NAMES indicates what character set the client uses to send SQL statements to the server. Thus, SET NAMES 'cp1251' tells the server, “future incoming messages from this client are in character set cp1251.” It also specifies the character set that the server should use for sending results back to the client. (For example, it indicates what character set to use for column values if you use a SELECT statement that produces a result set.)
A SET NAMES 'charset_name' statement is equivalent to these three statements:
SET character_set_client = <em >charset_name</em>;
SET character_set_results = <em >charset_name</em>;
SET character_set_connection = <em >charset_name</em>;
复制代码
Setting character_set_connection to charset_name also implicitly sets collation_connection to the default collation for charset_name. It is unnecessary to set that collation explicitly. To specify a particular collation to use for collation_connection, add a COLLATE clause:
SET NAMES '<em >charset_name</em>' COLLATE '<em >collation_name</em>'
NoteSome character sets cannot be used as the client character set. Attempting to use them with SET NAMES or SET CHARACTER SET produces an error. See Impermissible Client Character Sets.
Example: Suppose that column1 is defined as CHAR(5) CHARACTER SET latin2. If you do not say SET NAMES or SET CHARACTER SET, then for SELECT column1 FROM t, the server sends back all the values for column1 using the character set that the client specified when it connected. On the other hand, if you say SET NAMES 'latin1' or SET CHARACTER SET 'latin1' before issuing the SELECT statement, the server converts the latin2 values to latin1 just before sending results back. Conversion may be lossy for characters that are not in both character sets.
