TencentDB for SQL Server
- Release Notes and Announcements
- Announcements
- Product Introduction
- Product Architecture
- Instance Specifications
- Purchase Guide
- Product Pricing
- Getting Started
- Connecting to TencentDB for SQL Server Instance
- Operation Guide
- Maintaining Instance
- Adjusting Instance Configuration
- Read-Only Instance
- Network and Security
- Account Management
- Database Management
- Data Security
- Access Management
- Parameter Configuration
- Monitoring and Alarms
- Backup and Restoration
- Backup
- Setting Automatic Backup
- Log Management
- Publish-Subscribe
- SSIS
- Data Migration (New)
- Using DTS to Migrate Data
- Pre-Validation Failure Handling
- Data Migration (Legacy)
- Migrating Data from SQL Server Instance Purchased at Other Cloud Service Provider or Built In-house
- Practical Tutorial
- API Documentation
- Sales and fee related APIs
- Network management related APIs
- Account management related APIs
- Instance Management APIs
- Data security encryption related APIs
- Parameter configuration related APIs
- Log management related APIs
- Extended Event APIs
- Read only instance management related APIs
- Data migration (cold standby migration) related APIs
- Data migration (DTS old version) related APIs
- Making API Requests
- Database APIs
- Other APIs
- FAQs
- Service Agreement
- Performance Evaluation
DocumentationTencentDB for SQL ServerOperation GuideMaintaining InstanceModify Instance-level Character Set Collation
Modify Instance-level Character Set Collation
Last updated: 2024-11-12 16:50:25
TencentDB for SQL Server allows users to modify the instance-level character set collation when creating an instance and meets demand of some users to set the default character set themselves. This operation can be performed only on the purchase page. The character set of an instance provides a collation for system data, namely the case sensitivity and accent sensitivity. Selecting a collation for database will affect the results of relevant database operations.
This document describes how to modify the character set collation.
Note:
Dual-Node Local Disk Instance:
As modifying the instance-level character set collation requires to separately configure physical machine resources, submit a ticket for assistance and specify the desired character set collation if any modifications are needed before purchase.
For instances with modified character set collation, if a subsequent expansion involves data migration, submit a ticket for assistance.
The default collation of instance character set is Chinese_PRC_CI_AS.
Single-Node Cloud Disk/ Dual-Node Cloud Disk Instances:
The instance-level character set collation can be directly modified on the purchase page.
Prerequisites
If your instance is a dual-node local disk instance, submit a ticket before modifying the character set collation.
If you purchase a single-node cloud disk or dual-node cloud disk, you can directly modify the character set collation on purchase page with no need for application.
Directions
1. Log in to the TencentDB for SQL Server console.
2. In the instance list, click Create Database Instance.
3. On the instance purchase page, set the Character Set Collation under the Instance Configuration.
4. For more information on how to configure other parameters on the purchase page, see Creating TencentDB for SQL Server Instance. After setting all the parameters, click Buy Now.
5. You can view the configured character set collation on the Instance Details page.
Collation description
Collation Option | Description |
Case Sensitive (_CS) | Case sensitive. This option indicates that lowercase letters will precede their corresponding uppercase letters during sorting. |
Case Insensitive (_CI) | Case insensitive. This option indicates that the sorting will be case-insensitive. |
Accent Sensitive (_AS) | Accent sensitive. This option indicates that the sorting will be accent-sensitive; for example, "a" and "ấ" are different characters. |
Accent Insensitive (_AI) | Accent insensitive. |
Binary Value of Characters (_BIN) | This option indicates that the sorting is based on the binary values in character set, without regard to differences in phonetics, glyph, case, and accent marks. |
Instance character set suffix description
Instance Character Set 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. |
Collation by server level
The following table lists the default collations defined by certain OS region settings.
ID | Character Set Collation |
0 | Chinese_PRC_CI_AS |
1 | SQL_Latin1_General_CP1_CI_AI |
2 | Chinese_PRC_CS_AS |
3 | Latin1_General_CI_AS |
4 | Latin1_General_100_CI_AS |
5 | SQL_Latin1_General_CP1_CI_AS |
6 | SQL_Latin1_General_CP1250_CI_AS |
7 | SQL_Latin1_General_CP1251_CI_AS |
8 | SQL_Latin1_General_CP1253_CI_AI |
9 | SQL_Latin1_General_CP1253_CI_AS |
10 | SQL_Latin1_General_CP1254_CI_AS |
11 | SQL_Latin1_General_CP1255_CI_AS |
12 | SQL_Latin1_General_CP1256_CI_AS |
13 | SQL_Latin1_General_CP1257_CI_AS |
14 | SQL_Latin1_General_CP437_BIN |
15 | SQL_Latin1_General_CP437_BIN2 |
16 | SQL_Latin1_General_CP437_CI_AI |
17 | SQL_Latin1_General_CP437_CI_AS |
18 | SQL_Latin1_General_CP850_BIN |
19 | SQL_Latin1_General_CP850_BIN2 |
20 | SQL_Latin1_General_CP850_CI_AI |
21 | SQL_Latin1_General_CP850_CI_AS |
22 | SQL_Latin1_General_Pref_CP1_CI_AS |
23 | SQL_Latin1_General_Pref_CP437_CI_AS |
24 | SQL_Latin1_General_Pref_CP850_CI_AS |
25 | Albanian_CI_AI |
26 | Albanian_100_CI_AI |
27 | Arabic_CI_AI |
28 | Arabic_100_CI_AI |
29 | Assamese_100_CI_AI |
30 | Azeri_Cyrillic_100_CI_AI |
31 | Azeri_Latin_100_CI_AI |
32 | Bashkir_100_CI_AI |
33 | Bengali_100_CI_AI |
34 | Bosnian_Cyrillic_100_CI_AI |
35 | Bosnian_Latin_100_CI_AI |
36 | Breton_100_CI_AI |
37 | Chinese_Hong_Kong_Stroke_90_CI_AI |
38 | Chinese_PRC_CI_AI |
39 | Chinese_PRC_90_CI_AI |
40 | Chinese_PRC_Stroke_CI_AI |
41 | Chinese_PRC_Stroke_90_CI_AI |
42 | Chinese_Simplified_Pinyin_100_CI_AI |
43 | Chinese_Simplified_Stroke_Order_100_CI_AI |
44 | Chinese_Taiwan_Bopomofo_CI_AI |
45 | Chinese_Taiwan_Bopomofo_90_CI_AI |
46 | Chinese_Taiwan_Stroke_CI_AI |
47 | Chinese_Taiwan_Stroke_90_CI_AI |
48 | Chinese_Traditional_Bopomofo_100_CI_AI |
49 | Chinese_Traditional_Pinyin_100_CI_AI |
50 | Chinese_Traditional_Stroke_Count_100_CI_AI |
51 | Chinese_Traditional_Stroke_Order_100_CI_AI |
52 | Corsican_100_CI_AI |
53 | Croatian_CI_AI |
54 | Croatian_100_CI_AI |
55 | Cyrillic_General_CI_AI |
56 | Cyrillic_General_100_CI_AI |
57 | Czech_CI_AI |
58 | Czech_100_CI_AI |
59 | Danish_Greenlandic_100_CI_AI |
60 | Danish_Norwegian_CI_AI |
61 | Dari_100_CI_AI |
62 | Divehi_90_CI_AI |
63 | Divehi_100_CI_AI |
64 | Estonian_CI_AI |
65 | Estonian_100_CI_AI |
66 | Finnish_Swedish_CI_AI |
67 | Finnish_Swedish_100_CI_AI |
68 | French_CI_AI |
69 | French_100_CI_AI |
70 | Frisian_100_CI_AI |
71 | Georgian_Modern_Sort_CI_AI |
72 | Georgian_Modern_Sort_100_CI_AI |
73 | German_PhoneBook_CI_AI |
74 | German_PhoneBook_100_CI_AI |
75 | Greek_CI_AI |
76 | Greek_100_CI_AI |
77 | Hebrew_CI_AI |
78 | Hebrew_100_CI_AI |
79 | Hungarian_CI_AI |
80 | Hungarian_100_CI_AI |
81 | Hungarian_Technical_CI_AI |
82 | Hungarian_Technical_100_CI_AI |
83 | Icelandic_CI_AI |
84 | Icelandic_100_CI_AI |
85 | Indic_General_90_CI_AI |
86 | Indic_General_100_CI_AI |
87 | Japanese_CI_AI |
88 | Japanese_90_CI_AI |
89 | Japanese_Bushu_Kakusu_100_CI_AI |
90 | Japanese_Bushu_Kakusu_140_CI_AI |
91 | Japanese_Unicode_CI_AI |
92 | Japanese_XJIS_100_CI_AI |
93 | Japanese_XJIS_140_CI_AI |
94 | Kazakh_90_CI_AI |
95 | Kazakh_100_CI_AI |
96 | Khmer_100_CI_AI |
97 | Korean_90_CI_AI |
98 | Korean_100_CI_AI |
99 | Korean_Wansung_CI_AI |
100 | Lao_100_CI_AI |
101 | Latin1_General_CI_AI |
102 | Latin1_General_100_CI_AI |
103 | Latvian_CI_AI |
104 | Latvian_100_CI_AI |
105 | Lithuanian_CI_AI |
106 | Lithuanian_100_CI_AI |
107 | Macedonian_FYROM_90_CI_AI |
108 | Macedonian_FYROM_100_CI_AI |
109 | Maltese_100_CI_AI |
110 | Maori_100_CI_AI |
111 | Mapudungan_100_CI_AI |
112 | Modern_Spanish_CI_AI |
113 | Modern_Spanish_100_CI_AI |
114 | Mohawk_100_CI_AI |
115 | Nepali_100_CI_AI |
116 | Norwegian_100_CI_AI |
117 | Pashto_100_CI_AI |
118 | Persian_100_CI_AI |
119 | Polish_CI_AI |
120 | Polish_100_CI_AI |
121 | Romanian_CI_AI |
122 | Romanian_100_CI_AI |
123 | Romansh_100_CI_AI |
124 | Sami_Norway_100_CI_AI |
125 | Sami_Sweden_Finland_100_CI_AI |
126 | Serbian_Cyrillic_100_CI_AI |
127 | Serbian_Latin_100_CI_AI |
128 | Slovak_CI_AI |
129 | Slovak_100_CI_AI |
130 | Slovenian_CI_AI |
131 | Slovenian_100_CI_AI |
132 | Syriac_90_CI_AI |
133 | Syriac_100_CI_AI |
134 | Tamazight_100_CI_AI |
135 | Tatar_90_CI_AI |
136 | Tatar_100_CI_AI |
137 | Thai_CI_AI |
138 | Thai_100_CI_AI |
139 | Tibetan_100_CI_AI |
140 | Traditional_Spanish_CI_AI |
141 | Traditional_Spanish_100_CI_AI |
142 | Turkish_CI_AI |
143 | Turkish_100_CI_AI |
144 | Turkmen_100_CI_AI |
145 | Uighur_100_CI_AI |
146 | Ukrainian_CI_AI |
147 | Ukrainian_100_CI_AI |
148 | Upper_Sorbian_100_CI_AI |
149 | Urdu_100_CI_AI |
150 | Uzbek_Latin_90_CI_AI |
151 | Uzbek_Latin_100_CI_AI |
152 | Vietnamese_CI_AI |
153 | Vietnamese_100_CI_AI |
154 | Welsh_100_CI_AI |
155 | Yakut_100_CI_AI |
156 | SQL_AltDiction_CP850_CI_AI |
157 | Korean_Wansung_CI_AS |
158 | Chinese_PRC_BIN |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No