tencent cloud

TDSQL Boundless

DocumentaçãoTDSQL BoundlessGeneral ReferenceDatabase Parameter Descriptioncollation_server

collation_server

Baixar
Modo Foco
Tamanho da Fonte
Última atualização: 2026-05-26 16:30:17

Feature Description

collation_server is used to set the default collation for the server. A collation determines how strings are compared and sorted. Collations are also associated with character sets, such as utf8mb4_general_ci and utf8mb4_unicode_ci.
The primary function of the collation_server parameter is:
Set the default string comparison and collation for the server. This is very important for processing strings containing special characters or accent marks, because different collations may result in different comparison and collation outcomes.
When strings are compared on the server, the collation_server parameter determines how the comparison is performed. For example, during SQL query execution, if a string in a WHERE clause is compared against a column value on the server, the collation specified by the collation_server parameter is used for the comparison.
Typically, it is recommended to use a collation that matches the character_set_server parameter.

Attribute Description

Required
Description
Parameter Type
ENUM
Default Value
utf8mb4_0900_ai_ci
Value Range
latin1_general_cs
latin1_general_ci
latin1_bin
latin1_swedish_ci
gbk_chinese_ci
gbk_bin
utf8_general_ci
utf8_bin
utf8_unicode_ci
utf8mb4_general_ci
utf8mb4_0900_ai_ci
utf8mb4_bin
utf8mb4_unicode_ci
gb18030_bin
gb18030_chinese_ci
gb18030_unicode_520_ci
ujis_japanese_ci
ujis_bin
euckr_korean_ci
euckr_bin
Effective Scope
GLOBAL
SESSION
Restart Required
No
Anterior: character_set_serverPróximo: connect_timeout

Ajuda e Suporte

Esta página foi útil?

comentários