Export (0) Print
Expand All
1 out of 3 rated this helpful - Rate this topic

SQL Server Collation Name (Transact-SQL)

Is a single string that specifies the collation name for a SQL Server collation.

Topic link icon Transact-SQL Syntax Conventions


<SQL_collation_name> :: = 
     SQL_SortRules[_Pref]_CPCodepage_<ComparisonStyle>

<ComparisonStyle> ::=
    _CaseSensitivity_AccentSensitivity | _BIN
SortRules

A string identifying the alphabet or language whose sorting rules are applied when dictionary sorting is specified. Examples are Latin1_General or Polish.

Pref

Specifies uppercase preference.

Codepage

Specifies a one- to four-digit number that identifies the code page used by the collation. CP1 specifies code page 1252, for all other code pages the complete code page number is specified. For example, CP1251 specifies code page 1251 and CP850 specifies code page 850.

CaseSensitivity

CI specifies case-insensitive, CS specifies case-sensitive.

AccentSensitivity

AI specifies accent-insensitive, AS specifies accent-sensitive.

BIN

Specifies the binary sort order to be used.

The following table lists the SQL Server collation names.

Sort order ID

SQL Server collation name

30

SQL_Latin1_General_Cp437_BIN

31

SQL_Latin1_General_Cp437_CS_AS

32

SQL_Latin1_General_Cp437_CI_AS

33

SQL_Latin1_General_Pref_CP437_CI_AS

34

SQL_Latin1_General_Cp437_CI_AI

40

SQL_Latin1_General_Cp850_BIN

41

SQL_Latin1_General_Cp850_CS_AS

42

SQL_Latin1_General_Cp850_CI_AS

43

SQL_Latin1_General_Pref_CP850_CI_AS

44

SQL_Latin1_General_Cp850_CI_AI

49

SQL_1Xcompat_CP850_CI_AS

50

Latin1_General_BIN

51

SQL_Latin1_General_Cp1_CS_AS

52

SQL_Latin1_General_Cp1_CI_AS

53

SQL_Latin1_General_Pref_CP1_CI_AS

54

SQL_Latin1_General_Cp1_CI_AI

55

SQL_AltDiction_Cp850_CS_AS

56

SQL_AltDiction_Pref_CP850_CI_AS

57

SQL_AltDiction_Cp850_CI_AI

58

SQL_Scandinavian_Pref_Cp850_CI_AS

59

SQL_Scandinavian_Cp850_CS_AS

60

SQL_Scandinavian_Cp850_CI_AS

61

SQL_AltDiction_Cp850_CI_AS

71

Latin1_General_CS_AS

72

Latin1_General_CI_AS

73

Danish_Norwegian_CS_AS

74

Finnish_Swedish_CS_AS

75

Icelandic_CS_AS

80

Hungarian_BIN (or Albanian_BIN, Czech_BIN, and so on1)

81

SQL_Latin1_General_Cp1250_CS_AS

82

SQL_Latin1_General_Cp1250_CI_AS

83

SQL_Czech_Cp1250_CS_AS

84

SQL_Czech_Cp1250_CI_AS

85

SQL_Hungarian_Cp1250_CS_AS

86

SQL_Hungarian_Cp1250_CI_AS

87

SQL_Polish_Cp1250_CS_AS

88

SQL_Polish_Cp1250_CI_AS

89

SQL_Romanian_Cp1250_CS_AS

90

SQL_Romanian_Cp1250_CI_AS

91

SQL_Croatian_Cp1250_CS_AS

92

SQL_Croatian_Cp1250_CI_AS

93

SQL_Slovak_Cp1250_CS_AS

94

SQL_Slovak_Cp1250_CI_AS

95

SQL_Slovenian_Cp1250_CS_AS

96

SQL_Slovenian_Cp1250_CI_AS

104

Cyrillic_General_BIN (or Ukrainian_BIN, Macedonian_FYROM_90_BIN)

105

SQL_Latin1_General_Cp1251_CS_AS

106

SQL_Latin1_General_Cp1251_CI_AS

107

SQL_Ukrainian_Cp1251_CS_AS

108

SQL_Ukrainian_Cp1251_CI_AS

112

Greek_BIN

113

SQL_Latin1_General_Cp1253_CS_AS

114

SQL_Latin1_General_Cp1253_CI_AS

120

SQL_MixDiction_Cp1253_CS_AS

121

SQL_AltDiction_Cp1253_CS_AS

124

SQL_Latin1_General_Cp1253_CI_AI

128

Turkish_BIN

129

SQL_Latin1_General_Cp1254_CS_AS

130

SQL_Latin1_General_Cp1254_CI_AS

136

Hebrew_BIN

137

SQL_Latin1_General_Cp1255_CS_AS

138

SQL_Latin1_General_Cp1255_CI_AS

144

Arabic_BIN

145

SQL_Latin1_General_Cp1256_CS_AS

146

SQL_Latin1_General_Cp1256_CI_AS

153

SQL_Latin1_General_Cp1257_CS_AS

154

SQL_Latin1_General_Cp1257_CI_AS

155

SQL_Estonian_Cp1257_CS_AS

156

SQL_Estonian_Cp1257_CI_AS

157

SQL_Latvian_Cp1257_CS_AS

158

SQL_Latvian_Cp1257_CI_AS

159

SQL_Lithuanian_Cp1257_CS_AS

160

SQL_Lithuanian_Cp1257_CI_AS

183

SQL_Danish_Pref_Cp1_CI_AS

184

SQL_SwedishPhone_Pref_Cp1_CI_AS

185

SQL_SwedishStd_Pref_Cp1_CI_AS

186

SQL_Icelandic_Pref_Cp1_CI_AS

192

Japanese_BIN

193

Japanese_CI_AS

194

Korean_Wansung_BIN

195

Korean_Wansung_CI_AS

196

Chinese_Taiwan_Stroke_BIN

197

Chinese_Taiwan_Stroke_CI_AS

198

Chinese_PRC_BIN

199

Chinese_PRC_CI_AS

200

Japanese_CS_AS

201

Korean_Wansung_CS_AS

202

Chinese_Taiwan_Stroke_CS_AS

203

Chinese_PRC_CS_AS

204

Thai_BIN

205

Thai_CI_AS

206

Thai_CS_AS

210

SQL_EBCDIC037_CP1_CS_AS

211

SQL_EBCDIC273_CP1_CS_AS

212

SQL_EBCDIC277_CP1_CS_AS

213

SQL_EBCDIC278_CP1_CS_AS

214

SQL_EBCDIC280_CP1_CS_AS

215

SQL_EBCDIC284_CP1_CS_AS

216

SQL_EBCDIC285_CP1_CS_AS

217

SQL_EBCDIC297_CP1_CS_AS

1For Sort Order ID 80, use any of the Window collations with the code page of 1250, and binary order. For example: Albanian_BIN, Croatian_BIN, Czech_BIN, Romanian_BIN, Slovak_BIN, Slovenian_BIN.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.