tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
TencentDB for SQL Server
    Documentation
    Download PDF

    Modify Instance-level Character Set Collation

    Last updated: 2024-01-18 17:20:33
    Download PDF
      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 System Time Zone parameter.
      
      
      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 query the configured character set collation under Basic Info on the Instance Details tab.
      
      

      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
      
      Contact Us

      Contact our sales team or business advisors to help your business.

      Contact Us
      Technical Support

      Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

      Submit a Ticket
      7x24 Phone Support
      Copyright © 2013-2024 Tencent Cloud. All Rights Reserved.
      Privacy PolicyLegalCookie Policy