{"id":1038,"date":"2010-04-30T16:04:39","date_gmt":"2010-04-30T15:04:39","guid":{"rendered":"http:\/\/www.galhano.com\/blog\/?p=1038"},"modified":"2010-04-30T16:08:03","modified_gmt":"2010-04-30T15:08:03","slug":"sql-collations","status":"publish","type":"post","link":"http:\/\/galhano.com\/blog\/?p=1038","title":{"rendered":"SQL collations"},"content":{"rendered":"

Query:<\/strong><\/p>\n

select * from fn_helpcollations()
\nwhere name like ‘%SQL_Latin1_General_CP1_CI_AS%’
\nor name = ‘Latin1_General_CI_AS’
\nor name like ‘%cp1%’<\/p>\n

Query result:<\/strong><\/p>\n

<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Latin1_General_CI_AS<\/span><\/strong><\/td>\nLatin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive<\/span><\/strong><\/td>\n<\/tr>\n
SQL_AltDiction2_CP1253_CS_AS<\/td>\nLatin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 122 on Code Page 1253 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Croatian_CP1250_CI_AS<\/td>\nCroatian, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 92 on Code Page 1250 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Croatian_CP1250_CS_AS<\/td>\nCroatian, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 91 on Code Page 1250 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Czech_CP1250_CI_AS<\/td>\nCzech, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 84 on Code Page 1250 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Czech_CP1250_CS_AS<\/td>\nCzech, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 83 on Code Page 1250 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Danish_Pref_CP1_CI_AS<\/td>\nDanish-Norwegian, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 183 on Code Page 1252 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_EBCDIC037_CP1_CS_AS<\/td>\nLatin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 210 on Code Page 1252 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_EBCDIC273_CP1_CS_AS<\/td>\nGerman-PhoneBook, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 211 on Code Page 1252 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_EBCDIC277_CP1_CS_AS<\/td>\nDanish-Norwegian, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 212 on Code Page 1252 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_EBCDIC278_CP1_CS_AS<\/td>\nFinnish-Swedish, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 213 on Code Page 1252 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_EBCDIC280_CP1_CS_AS<\/td>\nLatin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 214 on Code Page 1252 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_EBCDIC284_CP1_CS_AS<\/td>\nModern-Spanish, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 215 on Code Page 1252 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_EBCDIC285_CP1_CS_AS<\/td>\nLatin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 216 on Code Page 1252 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_EBCDIC297_CP1_CS_AS<\/td>\nFrench, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 217 on Code Page 1252 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Estonian_CP1257_CI_AS<\/td>\nEstonian, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 156 on Code Page 1257 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Estonian_CP1257_CS_AS<\/td>\nEstonian, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 155 on Code Page 1257 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Hungarian_CP1250_CI_AS<\/td>\nHungarian, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 86 on Code Page 1250 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Hungarian_CP1250_CS_AS<\/td>\nHungarian, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 85 on Code Page 1250 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Icelandic_Pref_CP1_CI_AS<\/td>\nIcelandic, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 186 on Code Page 1252 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Latin1_General_CP1_CI_AI<\/td>\nLatin1-General, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 54 on Code Page 1252 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Latin1_General_CP1_CI_AS<\/td>\nLatin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Latin1_General_CP1_CS_AS<\/td>\nLatin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 51 on Code Page 1252 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Latin1_General_CP1250_CI_AS<\/td>\nLatin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 82 on Code Page 1250 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Latin1_General_CP1250_CS_AS<\/td>\nLatin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 81 on Code Page 1250 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Latin1_General_CP1251_CI_AS<\/strong><\/td>\nLatin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 106 on Code Page 1251 for non-Unicode Data<\/strong><\/td>\n<\/tr>\n
SQL_Latin1_General_CP1251_CS_AS<\/strong><\/td>\nLatin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 105 on Code Page 1251 for non-Unicode Data<\/strong><\/td>\n<\/tr>\n
SQL_Latin1_General_CP1253_CI_AI<\/td>\nLatin1-General, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 124 on Code Page 1253 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Latin1_General_CP1253_CI_AS<\/td>\nLatin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 114 on Code Page 1253 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Latin1_General_CP1253_CS_AS<\/td>\nLatin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 113 on Code Page 1253 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Latin1_General_CP1254_CI_AS<\/td>\nTurkish, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 130 on Code Page 1254 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Latin1_General_CP1254_CS_AS<\/td>\nTurkish, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 129 on Code Page 1254 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Latin1_General_CP1255_CI_AS<\/td>\nLatin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 138 on Code Page 1255 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Latin1_General_CP1255_CS_AS<\/td>\nLatin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 137 on Code Page 1255 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Latin1_General_CP1256_CI_AS<\/td>\nLatin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 146 on Code Page 1256 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Latin1_General_CP1256_CS_AS<\/td>\nLatin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 145 on Code Page 1256 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Latin1_General_CP1257_CI_AS<\/td>\nLatin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 154 on Code Page 1257 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Latin1_General_CP1257_CS_AS<\/td>\nLatin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 153 on Code Page 1257 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Latin1_General_Pref_CP1_CI_AS<\/td>\nLatin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 53 on Code Page 1252 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Latvian_CP1257_CI_AS<\/td>\nLatvian, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 158 on Code Page 1257 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Latvian_CP1257_CS_AS<\/td>\nLatvian, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 157 on Code Page 1257 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Lithuanian_CP1257_CI_AS<\/td>\nLithuanian, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 160 on Code Page 1257 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Lithuanian_CP1257_CS_AS<\/td>\nLithuanian, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 159 on Code Page 1257 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_MixDiction_CP1253_CS_AS<\/td>\nLatin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 120 on Code Page 1253 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Polish_CP1250_CI_AS<\/td>\nPolish, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 88 on Code Page 1250 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Polish_CP1250_CS_AS<\/td>\nPolish, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 87 on Code Page 1250 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Romanian_CP1250_CI_AS<\/td>\nRomanian, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 90 on Code Page 1250 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Romanian_CP1250_CS_AS<\/td>\nRomanian, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 89 on Code Page 1250 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Slovak_CP1250_CI_AS<\/td>\nSlovak, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 94 on Code Page 1250 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Slovak_CP1250_CS_AS<\/td>\nSlovak, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 93 on Code Page 1250 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Slovenian_CP1250_CI_AS<\/td>\nSlovenian, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 96 on Code Page 1250 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Slovenian_CP1250_CS_AS<\/td>\nSlovenian, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 95 on Code Page 1250 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_SwedishPhone_Pref_CP1_CI_AS<\/td>\nFinnish-Swedish, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 184 on Code Page 1252 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_SwedishStd_Pref_CP1_CI_AS<\/td>\nFinnish-Swedish, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 185 on Code Page 1252 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Ukrainian_CP1251_CI_AS<\/td>\nUkrainian, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 108 on Code Page 1251 for non-Unicode Data<\/td>\n<\/tr>\n
SQL_Ukrainian_CP1251_CS_AS<\/td>\nUkrainian, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 107 on Code Page 1251 for non-Unicode Data<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

Query: select * from fn_helpcollations() where name like ‘%SQL_Latin1_General_CP1_CI_AS%’ or name = ‘Latin1_General_CI_AS’ or name like ‘%cp1%’ Query result:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"close","ping_status":"close","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,104],"tags":[],"class_list":["post-1038","post","type-post","status-publish","format-standard","hentry","category-sql-server","category-transact-sql","author-admin"],"_links":{"self":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1038","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1038"}],"version-history":[{"count":4,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1038\/revisions"}],"predecessor-version":[{"id":1040,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1038\/revisions\/1040"}],"wp:attachment":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1038"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1038"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1038"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}