Subscribe

SQLServer-DBA.com Links

Subscribe to newsletter

Dba_db2_button

Powered by TypePad
SQL Server Collations and code page

29 January,2011 by Jack Vamvas

A brief note on collations. In this case:

SQL_Latin1_General_CP1_CI_AS

 V

 SQL_Latin1_General_CP850_CI_AS

 What is the difference?

 Firstly , some terminology :

Code Page – 1-4 digit number specifying code page . This code page define the bit patterns for the characters

Case Sensitivity  - CS – case sensitive , CI - insensitive

Accent SensitivityAI – accent insensitive , AS accent sensitive

 In the collations given above ,

CP1 = code page 1252

CP850 = code page 850

 Code page 1252 is Latin(ANSI)

Code Page 850 is Multilingual(MS-DOS Latin1)

 Looking at the 2 collations above – they are :

1)Both SQL collations

2)They are both Case Insensitive and Accent sensitive

3)The use different code pages.

 It is important to remember that whatever code page is chosen , it must be supported by the underlying operating system. If the users are using the same language that is straightforward, if different users are using different languages in the same instance, than collation choices need to be adjusted.

 Further , in the Multilanguage environment – consideration should be given to using Unicode based columns – (nchar,nvarchar,ntext) . This allows more effective code page conversion

Source:Jack Vamvas (http://www.sqlserver-dba.com)


Author: Jack Vamvas (http://www.sqlserver-dba.com)

******** *******

Subscribe to SQLServer-DBA.com

Latest posts delivered to you daily

Delivered by FeedBurner

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer