SET NAMES
语法
SET NAMES {'charset_name' [COLLATE 'collation_name'] | DEFAULT}
描述
这会设置character_set_client
、character_set_connection
和character_set_results
,同时还会隐式地设置会话级的系统变量collation_connection
为指定的字符集和排序规则。
这决定了client将语句发送给server端以及server端将语句执行结果返回给client端时使用的character set。
COLLATE
子句是可选的,如果不定义(或设置为DEFAULT
),将使用字符集的默认排序规则default collation for the character set。
See also
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.