Modifying Instance-Level Character Set Collation
다운로드
포커스 모드
폰트 크기
TencentDB for SQL Server allows you to modify the instance-level character set collation during instance creation. This feature meets the self-service configuration needs of some users regarding the default character set. This operation can only be performed on the purchase page and is not supported after purchase. The instance character set provides collation rules for system data, which include case-sensitivity and accent-sensitivity attributes. The collation rule you select for a database affects the results of related operations within that database.
This document describes how to modify the character set collation.
Note:
Two-node local disk instances:
Since modifying the instance-level collation requires a separate configuration of machine resources, if modification is needed, submit a ticket before purchasing to obtain a solution and specify the target character set to be adjusted.
For instances with adjusted character set collations, if subsequent scale-out involves data migration, submit a ticket to obtain a solution.
The default character set collation for an instance is: Chinese_PRC_CI_AS.
Single-node cloud disk/two-node cloud disk/multi-node cloud disk instances:
You can directly modify the instance-level character set collation on the purchase page.
Prerequisites
If your instance is a two-node local disk instance, you must submit a ticket to apply before modifying the character set collation.
If you purchase a single-node cloud disk, two-node cloud disk, or multi-node cloud disk instance, you can directly modify the character set collation on the purchase page with no need for application.
Operation Steps
1. Log in to the TencentDB for SQL Server console.
2. On the instance list page, click Create Database Instance.
3. Navigate to the instance purchase page, and under Instance Configuration, set the Character Set Collation.
4. For other parameter configurations on the purchase page, you can refer to Creating TencentDB for SQL Server Instance. After all parameter settings are completed, click Buy Now.
5. You can view the configured instance character set collation on the Instance Details page.
Collation Rules
Collation Option | Description |
Case-sensitive (_CS) | Case-sensitive. Indicates that lowercase letters will precede their corresponding uppercase letters during sorting. |
Case-insensitive (_CI) | Case-insensitive. Indicates that uppercase and lowercase letters are not distinguished during sorting. |
Accent-sensitive (_AS) | Distinguishes between accented and non-accented characters. For example, "a" and "ấ" are treated as different characters. |
Accent-insensitive (_AI) | Does not distinguish accents. |
Binary value of characters (_BIN) | Indicates sorting based on the binary values in the character set, disregarding differences in pinyin, glyphs, case, and accent symbols. |
Instance Character Set Suffix
Instance Collation Suffix | Description |
_CI_AI | Case-insensitive and accent-insensitive. |
_CI_AS | Case-insensitive and accent-sensitive. |
_CS_AI | Case-sensitive and accent-insensitive. |
_CS_AS | Case-sensitive and accent-sensitive. |
Server-Level Collation
The table below lists the default collations determined by some operating system (OS) locale settings.
ID | Collation |
0 | Chinese_PRC_CI_AS |
1 | SQL_Latin1_General_CP1_CI_AI |
2 | Latin1_General_CI_AS |
3 | Latin1_General_100_CI_AS |
4 | SQL_Latin1_General_CP1_CI_AS |
5 | SQL_Latin1_General_CP1250_CI_AS |
6 | SQL_Latin1_General_CP1251_CI_AS |
7 | SQL_Latin1_General_CP1253_CI_AI |
8 | SQL_Latin1_General_CP1253_CI_AS |
9 | SQL_Latin1_General_CP1254_CI_AS |
10 | SQL_Latin1_General_CP1255_CI_AS |
11 | SQL_Latin1_General_CP1256_CI_AS |
12 | SQL_Latin1_General_CP1257_CI_AS |
13 | SQL_Latin1_General_CP437_BIN |
14 | SQL_Latin1_General_CP437_BIN2 |
15 | SQL_Latin1_General_CP437_CI_AI |
16 | SQL_Latin1_General_CP437_CI_AS |
17 | SQL_Latin1_General_CP850_BIN |
18 | SQL_Latin1_General_CP850_BIN2 |
19 | SQL_Latin1_General_CP850_CI_AI |
20 | SQL_Latin1_General_CP850_CI_AS |
21 | SQL_Latin1_General_Pref_CP1_CI_AS |
22 | SQL_Latin1_General_Pref_CP437_CI_AS |
23 | SQL_Latin1_General_Pref_CP850_CI_AS |
24 | Albanian_CI_AI |
25 | Albanian_100_CI_AI |
26 | Arabic_CI_AI |
27 | Arabic_100_CI_AI |
28 | Assamese_100_CI_AI |
29 | Azeri_Cyrillic_100_CI_AI |
30 | Azeri_Latin_100_CI_AI |
31 | Bashkir_100_CI_AI |
32 | Bengali_100_CI_AI |
33 | Bosnian_Cyrillic_100_CI_AI |
34 | Bosnian_Latin_100_CI_AI |
35 | Breton_100_CI_AI |
36 | Chinese_Hong_Kong_Stroke_90_CI_AI |
37 | Chinese_PRC_CI_AI |
38 | Chinese_PRC_90_CI_AI |
39 | Chinese_PRC_Stroke_CI_AI |
40 | Chinese_PRC_Stroke_90_CI_AI |
41 | Chinese_Simplified_Pinyin_100_CI_AI |
42 | Chinese_Simplified_Stroke_Order_100_CI_AI |
43 | Chinese_Taiwan_Bopomofo_CI_AI |
44 | Chinese_Taiwan_Bopomofo_90_CI_AI |
45 | Chinese_Taiwan_Stroke_CI_AI |
46 | Chinese_Taiwan_Stroke_90_CI_AI |
47 | Chinese_Traditional_Bopomofo_100_CI_AI |
48 | Chinese_Traditional_Pinyin_100_CI_AI |
49 | Chinese_Traditional_Stroke_Count_100_CI_AI |
50 | Chinese_Traditional_Stroke_Order_100_CI_AI |
51 | Corsican_100_CI_AI |
52 | Croatian_CI_AI |
53 | Croatian_100_CI_AI |
54 | Cyrillic_General_CI_AI |
55 | Cyrillic_General_100_CI_AI |
56 | Czech_CI_AI |
57 | Czech_100_CI_AI |
58 | Danish_Greenlandic_100_CI_AI |
59 | Danish_Norwegian_CI_AI |
60 | Dari_100_CI_AI |
61 | Divehi_90_CI_AI |
62 | Divehi_100_CI_AI |
63 | Estonian_CI_AI |
64 | Estonian_100_CI_AI |
65 | Finnish_Swedish_CI_AI |
66 | Finnish_Swedish_100_CI_AI |
67 | French_CI_AI |
68 | French_100_CI_AI |
69 | Frisian_100_CI_AI |
70 | Georgian_Modern_Sort_CI_AI |
71 | Georgian_Modern_Sort_100_CI_AI |
72 | German_PhoneBook_CI_AI |
73 | German_PhoneBook_100_CI_AI |
74 | Greek_CI_AI |
75 | Greek_100_CI_AI |
76 | Hebrew_CI_AI |
77 | Hebrew_100_CI_AI |
78 | Hungarian_CI_AI |
79 | Hungarian_100_CI_AI |
80 | Hungarian_Technical_CI_AI |
81 | Hungarian_Technical_100_CI_AI |
82 | Icelandic_CI_AI |
83 | Icelandic_100_CI_AI |
84 | Indic_General_90_CI_AI |
85 | Indic_General_100_CI_AI |
86 | Japanese_CI_AI |
87 | Japanese_90_CI_AI |
88 | Japanese_Bushu_Kakusu_100_CI_AI |
89 | Japanese_Bushu_Kakusu_140_CI_AI |
90 | Japanese_Unicode_CI_AI |
91 | Japanese_XJIS_100_CI_AI |
92 | Japanese_XJIS_140_CI_AI |
93 | Kazakh_90_CI_AI |
94 | Kazakh_100_CI_AI |
95 | Khmer_100_CI_AI |
96 | Korean_90_CI_AI |
97 | Korean_100_CI_AI |
98 | Korean_Wansung_CI_AI |
99 | Lao_100_CI_AI |
100 | Latin1_General_CI_AI |
101 | Latin1_General_100_CI_AI |
102 | Latvian_CI_AI |
103 | Latvian_100_CI_AI |
104 | Lithuanian_CI_AI |
105 | Lithuanian_100_CI_AI |
106 | Macedonian_FYROM_90_CI_AI |
107 | Macedonian_FYROM_100_CI_AI |
108 | Maltese_100_CI_AI |
109 | Maori_100_CI_AI |
110 | Mapudungan_100_CI_AI |
111 | Modern_Spanish_CI_AI |
112 | Modern_Spanish_100_CI_AI |
113 | Mohawk_100_CI_AI |
114 | Nepali_100_CI_AI |
115 | Norwegian_100_CI_AI |
116 | Pashto_100_CI_AI |
117 | Persian_100_CI_AI |
118 | Polish_CI_AI |
119 | Polish_100_CI_AI |
120 | Romanian_CI_AI |
121 | Romanian_100_CI_AI |
122 | Romansh_100_CI_AI |
123 | Sami_Norway_100_CI_AI |
124 | Sami_Sweden_Finland_100_CI_AI |
125 | Serbian_Cyrillic_100_CI_AI |
126 | Serbian_Latin_100_CI_AI |
127 | Slovak_CI_AI |
128 | Slovak_100_CI_AI |
129 | Slovenian_CI_AI |
130 | Slovenian_100_CI_AI |
131 | Syriac_90_CI_AI |
132 | Syriac_100_CI_AI |
133 | Tamazight_100_CI_AI |
134 | Tatar_90_CI_AI |
135 | Tatar_100_CI_AI |
136 | Thai_CI_AI |
137 | Thai_100_CI_AI |
138 | Tibetan_100_CI_AI |
139 | Traditional_Spanish_CI_AI |
140 | Traditional_Spanish_100_CI_AI |
141 | Turkish_CI_AI |
142 | Turkish_100_CI_AI |
143 | Turkmen_100_CI_AI |
144 | Uighur_100_CI_AI |
145 | Ukrainian_CI_AI |
146 | Ukrainian_100_CI_AI |
147 | Upper_Sorbian_100_CI_AI |
148 | Urdu_100_CI_AI |
149 | Uzbek_Latin_90_CI_AI |
150 | Uzbek_Latin_100_CI_AI |
151 | Vietnamese_CI_AI |
152 | Vietnamese_100_CI_AI |
153 | Welsh_100_CI_AI |
154 | Yakut_100_CI_AI |
155 | SQL_AltDiction_CP850_CI_AI |
156 | Korean_Wansung_CI_AS |
157 | Chinese_PRC_BIN |
158 | Chinese_PRC_CS_AS_KS_WS |
159 | Chinese_Taiwan_Stroke_CI_AS |
160 | Thai_CI_AS |
Related APIs
API | Description |
This API (DescribeCollationTimeZone) is used to query the character sets and time zones supported by an instance. |
피드백