Collation Settings in Setup
此页面有用吗？
您对此内容的反馈非常重要。 请告诉我们您的想法。
更多反馈？
1500 个剩余字符
我们非常感谢您的反馈。
Collation Settings in Setup
SQL Server 2008 R2
Many server-to-server activities can fail or yield inconsistent results if collation settings are not consistent across servers. To avoid this, select a Windows locale or SQL Server collation (SQL_*) to match the collation settings in other instances of SQL Server.SQL Server 2008 supports setting collations at the following levels:ServerDatabaseColumnExpressionFor more information, see
and .Binary collations sort and compare data in SQL Server based on the bit pattern for each character. Each binary collation in SQL Server maps to a specific language locale and ANSI code page, and each performs case-sensitive and accent-sensitive data sorts. For more information, see
and .Select this option to match settings with English-language versions SQL Server 2005 or earlier versions. For more information, see .The default installation settings are determined by the Windows system locale. The server-level collation can either be changed during setup, or by changing the Windows system locale before installation. The default collations are set to the oldest available version that is associated with each specific locale. This is due to backwards compatibility reasons. Therefore, these are not always the recommended collations. To take advantage of the
SQL Server 2008 features, change the default installation settings for Windows collations..To set the Windows locale for operating systems before Windows Vista, in Contol Panel, find the Windows system locale name on the Advanced tab in Regional and Language Options. In Windows Vista, use the Formats tab.Select the name of a specific Windows collation from the Collation Designator list. For example, use Latin1_General for the U.S. English character set.Select sort order options to use with the selected collation designator. Binary is the fastest sorting order and is case-sensitive, but can yield unexpected sort orders. If Binary is selected, the Case-sensitive, Accent-sensitive, Kana-sensitive, and Width-sensitive options are not available. For more information, see .In Control Panel, find the Windows system locale name on the Advanced tab in Regional and Language Options. In Windows Vista, use the Formats" tab. The following table shows the corresponding collation designator to match collation settings with an existing Windows locale:Windows localeWindows LCIDSQL LCIDDefault collationAfrikaans (South Africa)0x04360x0409Latin1_General_CI_ASAlbanian (Albania)0x041c0x041cAlbanian_CI_ASAlsatian (France)0x04840x0409Latin1_General_CI_ASAmharic (Ethiopia)0x045e0x0409Latin1_General_CI_ASArabic (Algeria)0x14010x0401Arabic_CI_ASArabic (Bahrain)0x3c010x0401Arabic_CI_ASArabic (Egypt)0x0c010x0401Arabic_CI_ASArabic (Iraq)0x08010x0401Arabic_CI_ASArabic (Jordan)0x2c010x0401Arabic_CI_ASArabic (Kuwait)0x34010x0401Arabic_CI_ASArabic (Lebanon)0x30010x0401Arabic_CI_ASArabic (Libya)0x10010x0401Arabic_CI_ASArabic (Morocco)0x18010x0401Arabic_CI_ASArabic (Oman)0x20010x0401Arabic_CI_ASArabic (Qatar)0x40010x0401Arabic_CI_ASArabic (Saudi Arabia)0x04010x0401Arabic_CI_ASArabic (Syria)0x28010x0401Arabic_CI_ASArabic (Tunisia)0x1c010x0401Arabic_CI_ASArabic (U.A.E.)0x38010x0401Arabic_CI_ASArabic (Yemen)0x24010x0401Arabic_CI_ASArmenian (Armenia)0x042b0x0419Latin1_General_CI_ASAssamese (India)0x044d0x044dNot available at server levelAzeri (Azerbaijan, Cyrillic)0x082c0x082cDeprecated, not available at server levelAzeri (Azerbaijan, Latin)0x042c0x042cDeprecated, not available at server levelBashkir (Russia)0x046d0x046dLatin1_General_CI_AIBasque (Basque)0x042d0x0409Latin1_General_CI_ASBelarusian (Belarus)0x04230x0419Cyrillic_General_CI_ASBengali (Bangladesh)0x08450x0445Not available at server levelBengali (India)0x04450x0439Not available at server levelBosnian (Bosnia and Herzegovina, Cyrillic)0x201a0x201aLatin1_General_CI_AIBosnian (Bosnia and Herzegovina, Latin)0x141a0x141aLatin1_General_CI_AIBreton (France)0x047e0x047eLatin1_General_CI_AIBulgarian (Bulgaria)0x04020x0419Cyrillic_General_CI_ASCatalan (Catalan)0x04030x0409Latin1_General_CI_ASChinese (Hong Kong SAR, PRC)0x0c040x0404Chinese_Taiwan_Stroke_CI_ASChinese (Macao SAR)0x14040x1404Latin1_General_CI_AIChinese (Macau)*0x214040x21404Latin1_General_CI_AIChinese (PRC)0x08040x0804Chinese_PRC_CI_ASChinese (PRC)*0x208040x20804Chinese_PRC_Stroke_CI_ASChinese (Singapore)0x10040x0804Chinese_PRC_CI_ASChinese (Singapore)*0x210040x20804Chinese_PRC_Stroke_CI_ASChinese (Taiwan)*0x304040x30404Chinese_Taiwan_Bopomofo_CI_ASChinese (Taiwan)0x04040x0404Chinese_Taiwan_Stroke_CI_ASCorsican (France)0x04830x0483Latin1_General_CI_AICroatian (Bosnia and Herzegovina, Latin)0x101a0x041aCroatian_CI_ASCroatian (Croatia)0x041a0x041aCroatian_CI_ASCzech (Czech Republic)0x04050x0405Czech_CI_ASDanish (Denmark)0x04060x0406Danish_Norwegian_CI_ASDari (Afghanistan)0x048c0x048cLatin1_General_CI_AIDivehi (Maldives)0x04650x0465Not available at server levelDutch (Belgium)0x08130x0409Latin1_General_CI_ASDutch (Netherlands)0x04130x0409Latin1_General_CI_ASEnglish (Australia)0x0c090x0409Latin1_General_CI_ASEnglish (Belize)0x28090x0409Latin1_General_CI_ASEnglish (Canada)0x10090x0409Latin1_General_CI_ASEnglish (Caribbean)0x24090x0409Latin1_General_CI_ASEnglish (India)0x40090x0409Latin1_General_CI_ASEnglish (Ireland)0x18090x0409Latin1_General_CI_ASEnglish (Jamaica)0x20090x0409Latin1_General_CI_ASEnglish (Malaysia)0x44090x0409Latin1_General_CI_ASEnglish (New Zealand)0x14090x0409Latin1_General_CI_ASEnglish (Philippines)0x34090x0409Latin1_General_CI_ASEnglish (Singapore)0x48090x0409Latin1_General_CI_ASEnglish (South Africa)0x1c090x0409Latin1_General_CI_ASEnglish (Trinidad and Tobago)0x2c090x0409Latin1_General_CI_ASEnglish (United Kingdom)0x08090x0409Latin1_General_CI_ASEnglish (United States)0x04090x0409SQL_Latin1_General_CP1_CI_ASEnglish (Zimbabwe)0x30090x0409Latin1_General_CI_ASEstonian (Estonia)0x04250x0425Estonian_CI_ASFaroese (Faroe Islands)0x04380x0409Latin1_General_CI_ASFilipino (Philippines)0x04640x0409Latin1_General_CI_ASFinnish (Finland)0x040b0x040bFinnish_Swedish_CI_ASFrench (Belgium)0x080c0x040cFrench_CI_ASFrench (Canada)0x0c0c0x040cFrench_CI_ASFrench (France)0x040c0x040cFrench_CI_ASFrench (Luxembourg)0x140c0x040cFrench_CI_ASFrench (Monaco)0x180c0x040cFrench_CI_ASFrench (Switzerland)0x100c0x040cFrench_CI_ASFrisian (Netherlands)0x04620x0462Latin1_General_CI_AIGalician (Spain)0x04560x0409Latin1_General_CI_ASGeorgian (Georgia)*0x104370x10437Georgian_Modern_Sort_CI_ASGeorgian (Georgia)0x04370x0419Latin1_General_CI_ASGerman - Phone Book Sort (DIN)*0x104070x10407German_PhoneBook_CI_ASGerman (Austria)0x0c070x0409Latin1_General_CI_ASGerman (Germany)0x04070x0409Latin1_General_CI_ASGerman (Liechtenstein)0x14070x0409Latin1_General_CI_ASGerman (Luxembourg)0x10070x0409Latin1_General_CI_ASGerman (Switzerland)0x08070x0409Latin1_General_CI_ASGreek (Greece)0x04080x0408Greek_CI_ASGreenlandic (Greenland)0x046f0x0406Danish_Norwegian_CI_ASGujarati (India)0x04470x0439Not available at server levelHausa (Nigeria, Latin)0x04680x0409Latin1_General_CI_ASHebrew (Israel)0x040d0x040dHebrew_CI_ASHindi (India)0x04390x0439Not available at server levelHungarian (Hungary)0x040e0x040eHungarian_CI_ASHungarian Technical Sort*0x1040e0x1040eHungarian_Technical_CI_ASIcelandic (Iceland)0x040f0x040fIcelandic_CI_ASIgbo (Nigeria)0x04700x0409Latin1_General_CI_ASIndonesian (Indonesia)0x04210x0409Latin1_General_CI_ASInuktitut (Canada, Latin)0x085d0x0409Latin1_General_CI_ASInuktitut (Syllabics) Canada0x045d0x045dLatin1_General_CI_AIIrish (Ireland)0x083c0x0409Latin1_General_CI_ASItalian (Italy)0x04100x0409Latin1_General_CI_ASItalian (Switzerland)0x08100x0409Latin1_General_CI_ASJapanese (Japan XJIS)0x04110x0411Japanese_CI_ASJapanese (Japan)*0x0404110x40411Latin1_General_CI_AIKannada (India)0x044b0x0439Not available at server levelKazakh (Kazakhstan)0x043f0x043fKazakh_90_CI_ASKhmer (Cambodia)0x04530x0453Not available at server levelK'iche (Guatemala)0x04860x0c0aModern_Spanish_CI_ASKinyarwanda (Rwanda)0x04870x0409Latin1_General_CI_ASKonkani (India)0x04570x0439Not available at server levelKorean (Korea Dictionary Sort)0x04120x0412Korean_Wansung_CI_ASKyrgyz (Kyrgyzstan)0x04400x0419Cyrillic_General_CI_ASLao (Lao PDR)0x04540x0454Not available at server levelLatvian (Latvia)0x04260x0426Latvian_CI_ASLithuanian (Lithuania)0x04270x0427Lithuanian_CI_ASLower Sorbian (Germany)0x082e0x0409Latin1_General_CI_ASLuxembourgish (Luxembourg)0x046e0x0409Latin1_General_CI_ASMacedonian (Macedonia, FYROM)0x042f0x042fMacedonian_FYROM_90_CI_ASMalay (Brunei Darussalam)0x083e0x0409Latin1_General_CI_ASMalay (Malaysia)0x043e0x0409Latin1_General_CI_ASMalayalam (India)0x044c0x0439Not available at server levelMaltese (Malta)0x043a0x043aLatin1_General_CI_AIMaori (New Zealand)0x04810x0481Latin1_General_CI_AIMapudungun (Chile)0x047a0x047aLatin1_General_CI_AIMarathi (India)0x044e0x0439Not available at server levelMohawk (Canada)0x047c0x047cLatin1_General_CI_AIMongolian (Mongolia)0x04500x0419Cyrillic_General_CI_ASMongolian (PRC)0x08500x0419Cyrillic_General_CI_ASNepali (Nepal)0x04610x0461Not available at server levelNorwegian (Bokm?l, Norway)0x04140x0414Latin1_General_CI_AINorwegian (Nynorsk, Norway)0x08140x0414Latin1_General_CI_AIOccitan (France)0x04820x040cFrench_CI_ASOriya (India)0x04480x0439Not available at server levelPashto (Afghanistan)0x04630x0463Not available at server levelPersian (Iran)0x04290x0429Latin1_General_CI_AIPolish (Poland)0x04150x0415Polish_CI_ASPortuguese (Brazil)0x04160x0409Latin1_General_CI_ASPortuguese (Portugal)0x08160x0409Latin1_General_CI_ASPunjabi (India)0x04460x0439Not available at server levelQuechua (Bolivia)0x046b0x0409Latin1_General_CI_ASQuechua (Ecuador)0x086b0x0409Latin1_General_CI_ASQuechua (Peru)0x0c6b0x0409Latin1_General_CI_ASRomanian (Romania)0x04180x0418Romanian_CI_ASRomansh (Switzerland)0x04170x0417Latin1_General_CI_AIRussian (Russia)0x04190x0419Cyrillic_General_CI_ASSami (Inari, Finland)0x243b0x083bLatin1_General_CI_AISami (Lule, Norway)0x103b0x043bLatin1_General_CI_AISami (Lule, Sweden)0x143b0x083bLatin1_General_CI_AISami (Northern, Finland)0x0c3b0x083bLatin1_General_CI_AISami (Northern, Norway)0x043b0x043bLatin1_General_CI_AISami (Northern, Sweden)0x083b0x083bLatin1_General_CI_AISami (Skolt, Finland)0x203b0x083bLatin1_General_CI_AISami (Southern, Norway)0x183b0x043bLatin1_General_CI_AISami (Southern, Sweden)0x1c3b0x083bLatin1_General_CI_AISanskrit (India)0x044f0x0439Not available at server levelSerbian (Bosnia and Herzegovina, Cyrillic)0x1c1a0x0c1aLatin1_General_CI_AISerbian (Bosnia and Herzegovina, Latin)0x181a0x081aLatin1_General_CI_AISerbian (Serbia, Cyrillic)0x0c1a0x0c1aLatin1_General_CI_AISerbian (Serbia, Latin)0x081a0x081aLatin1_General_CI_AISesotho sa Leboa/Northern Sotho (South Africa)0x046c0x0409Latin1_General_CI_ASSetswana/Tswana (South Africa)0x04320x0409Latin1_General_CI_ASSinhala (Sri Lanka)0x045b0x0439Not available at server levelSlovak (Slovakia)0x041b0x041bSlovak_CI_ASSlovenian (Slovenia)0x04240x0424Slovenian_CI_ASSpanish (Argentina)0x2c0a0x0c0aModern_Spanish_CI_ASSpanish (Bolivia)0x400a0x0c0aModern_Spanish_CI_ASSpanish (Chile)0x340a0x0c0aModern_Spanish_CI_ASSpanish (Colombia)0x240a0x0c0aModern_Spanish_CI_ASSpanish (Costa Rica)0x140a0x0c0aModern_Spanish_CI_ASSpanish (Dominican Republic)0x1c0a0x0c0aModern_Spanish_CI_ASSpanish (Ecuador)0x300a0x0c0aModern_Spanish_CI_ASSpanish (El Salvador)0x440a0x0c0aModern_Spanish_CI_ASSpanish (Guatemala)0x100a0x0c0aModern_Spanish_CI_ASSpanish (Honduras)0x480a0x0c0aModern_Spanish_CI_ASSpanish (Mexico)0x080a0x0c0aModern_Spanish_CI_ASSpanish (Nicaragua)0x4c0a0x0c0aModern_Spanish_CI_ASSpanish (Panama)0x180a0x0c0aModern_Spanish_CI_ASSpanish (Paraguay)0x3c0a0x0c0aModern_Spanish_CI_ASSpanish (Peru)0x280a0x0c0aModern_Spanish_CI_ASSpanish (Puerto Rico)0x500a0x0c0aModern_Spanish_CI_ASSpanish (Spain)0x0c0a0x0c0aModern_Spanish_CI_ASSpanish (Spain, Traditional Sort)0x040a0x040aTraditional_Spanish_CI_ASSpanish (United States)0x540a0x0409Latin1_General_CI_ASSpanish (Uruguay)0x380a0x0c0aModern_Spanish_CI_ASSpanish (Venezuela)0x200a0x0c0aModern_Spanish_CI_ASSwahili (Kenya)0x04410x0409Latin1_General_CI_ASSwedish (Finland)0x081d0x040bFinnish_Swedish_CI_ASSwedish (Sweden)0x041d0x040bFinnish_Swedish_CI_ASSyriac (Syria)0x045a0x045aNot available at server levelTajik (Tajikistan)0x04280x0419Cyrillic_General_CI_ASTamazight (Algeria, Latin)0x085f0x085fLatin1_General_CI_AITamil (India)0x04490x0439Not available at server levelTatar (Russia)0x04440x0444Cyrillic_General_CI_ASTelugu (India)0x044a0x0439Not available at server levelThai (Thailand)0x041e0x041eThai_CI_ASTibetan (PRC)0x04510x0451Not available at server levelTurkish (Turkey)0x041f0x041fTurkish_CI_ASTurkmen (Turkmenistan)0x04420x0442Latin1_General_CI_AIUighur (PRC)0x04800x0480Latin1_General_CI_AIUkrainian (Ukraine)0x04220x0422Ukrainian_CI_ASUpper Sorbian (Germany)0x042e0x042eLatin1_General_CI_AIUrdu (Pakistan)0x04200x0420Latin1_General_CI_AIUzbek (Uzbekistan, Cyrillic)0x08430x0419Cyrillic_General_CI_ASUzbek (Uzbekistan, Latin)0x04430x0443Uzbek_Latin_90_CI_ASVietnamese (Vietnam)0x042a0x042aVietnamese_CI_ASWelsh (United Kingdom)0x04520x0452Latin1_General_CI_AIWolof (Senegal)0x04880x040cFrench_CI_ASXhosa/isiXhosa (South Africa)0x04340x0409Latin1_General_CI_ASYakut (Russia)0x04850x0485Latin1_General_CI_AIYi (PRC)0x04780x0409Latin1_General_CI_ASYoruba (Nigeria)0x046a0x0409Latin1_General_CI_ASZulu/isiZulu (South Africa)0x04350x0409Latin1_General_CI_AS
您对此内容的反馈非常重要。请告诉我们您的想法。
更多反馈？
1500 个剩余字符
我们非常感谢您的反馈。
开发人员中心in the setting of是什么意思_百度知道
in the setting of是什么意思
提问者采纳
敬请及时采纳。~你的采纳是我前进的动力~~O(∩_∩)O，~如果你认可我的回答，请及时点击【采纳为满意回答】按钮~~手机提问的朋友在客户端右上角评价点【满意】即可，记得好评和采纳in the setting of在设置请采纳如果你认可我的回答
数学爱好者
其他类似问题
为您推荐：
其他2条回答
每天都开心V_V，thanks（thx）！望采纳。中亲。：高老师祝你学习进步。在确定（设置）
in the setting of在设置
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁当前位置： &
settings -memory in use是什么意思
中文翻译使用中的储存:&&&&n. 1.安装；装配；装置；安放。 2.(机器的)底座。 ...:&&&&n. 1.记忆；记忆力；【自动化】存储器；信息存储方式； ...:&&&&In ＝【化学】 indium (铟). :&&&&n. 1.使用，利用，应用；使用的机会[需要]。 2.使 ...
相邻词汇热门词汇Self-directed Team Models in Healthcare Settings What is ：自我管理的..
扫扫二维码，随身浏览文档
手机或平板扫扫即可继续访问
Self-directed Team Models in Healthcare Settings What is ：自我管理的团队在医疗环境模型是什么
举报该文档为侵权文档。
举报该文档含有违规或不良信息。
反馈该文档无法正常浏览。
举报该文档为重复文档。
推荐理由：
将文档分享至：
分享完整地址
文档地址：
粘贴到BBS或博客
flash地址：
支持嵌入FLASH地址的网站使用
html代码：
&embed src='/DocinViewer--144.swf' width='100%' height='600' type=application/x-shockwave-flash ALLOWFULLSCREEN='true' ALLOWSCRIPTACCESS='always'&&/embed&
450px*300px480px*400px650px*490px
支持嵌入HTML代码的网站使用
您的内容已经提交成功
您所提交的内容需要审核后才能发布，请您等待！
3秒自动关闭窗口免费WiFi - 手机版
新一代“蹭网”神器！
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& 扫描二维码下载APP
随身WiFi驱动 - 电脑版
最新版本：5.3
免费WiFi - 电脑版
最新版本：5.3
看视频玩转360随身WiFi
北京奇虎科技有限公司
Copyright &2005- All Rights Reserved. 京ICP证080047号