Collation

I'm rebuilding an application server and am trying to figure out how I can
get the right collation as what my old server has. I haven't installed SQL
Server in quite a while, and this is my first time installing SQL Server 2005
and it's a lot different.
The collation on my old server is SQL_Latin1_General_CP1_Cl_AS how does that
equate to all the SQL Collations I have to choose from? The default is
dictionary order, case-insensitive, for use with 1252 Character Set.
I'm not sure what the CP1_Cl_AS means. Does anyone know what I need to
choose in order to get the right collation? If memory serves me correctly
changing this after the fact isn't recommended (this was SQL 2000).Hi Penny,
This is from BOL:
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.
Source:
http://msdn2.microsoft.com/en-us/library/ms180175.aspx
In your case, If you want collation compatibility then you must go with CP
1252 (Because CP1 = Code Page 1252), Case Intensive (CI), Accent Sensetive
(AS).
Note:
Latin1_general use CP 1252
Ekrem Ã?nsoy
"Penny" <Penny@.discussions.microsoft.com> wrote in message
news:DD3B734B-8436-4EED-89E5-CD3E31DC960A@.microsoft.com...
> I'm rebuilding an application server and am trying to figure out how I can
> get the right collation as what my old server has. I haven't installed
> SQL
> Server in quite a while, and this is my first time installing SQL Server
> 2005
> and it's a lot different.
> The collation on my old server is SQL_Latin1_General_CP1_Cl_AS how does
> that
> equate to all the SQL Collations I have to choose from? The default is
> dictionary order, case-insensitive, for use with 1252 Character Set.
> I'm not sure what the CP1_Cl_AS means. Does anyone know what I need to
> choose in order to get the right collation? If memory serves me correctly
> changing this after the fact isn't recommended (this was SQL 2000).
>