SQL Server Collations and code page

29 January,2011 by Jack Vamvas

A brief note on collations. In this case:




 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

Read More

Import Data from AS400 to SQL Server

SQL Server Linked Servers and User permissions

SQL Server – Datetime date range , AS400 and OPENQUERY

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


Verify your Comment

Previewing your Comment

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

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.


Post a comment on SQL Server Collations and code page

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