Collation Confusion

Greetings!
I'm trying to install SQL Server 2000 (Standard edition) on a new server to
mirror the version on an older server. The trouble I'm having is with
identifying the settings I need in order to match collations.
The instance of SQL Server on the old server has a collation described as
'SQL_Latin1_General_CP1_CI_AS'. I realise that 'CI' and 'AS' refer to
case-insensitive and accent-sensitive respectively, but what does 'CP1'
relate to?
I've searched through various resources but they all seem to avoid
describing that one crucial bit of information! Can anyone help?Code page 1
"Mario" <someone.else@.microsoft.com> wrote in message
news:O3bumugWEHA.1368@.TK2MSFTNGP10.phx.gbl...
> Greetings!
> I'm trying to install SQL Server 2000 (Standard edition) on a new server
to
> mirror the version on an older server. The trouble I'm having is with
> identifying the settings I need in order to match collations.
> The instance of SQL Server on the old server has a collation described as
> 'SQL_Latin1_General_CP1_CI_AS'. I realise that 'CI' and 'AS' refer to
> case-insensitive and accent-sensitive respectively, but what does 'CP1'
> relate to?
> I've searched through various resources but they all seem to avoid
> describing that one crucial bit of information! Can anyone help?
>|||In setup you should select "Dictionary order, case-insensitive, for use
with 1252 character set" in the collation selection dialog. This is the
default collation for U.S. English SQL Servers.
--
Bart Duncan
Microsoft SQL Server Support
Please reply to the newsgroup only - thanks.
This posting is provided "AS IS" with no warranties, and confers no
rights.
From: "Adam Machanic" <amachanic@.hotmail._removetoemail_.com>
References: <O3bumugWEHA.1368@.TK2MSFTNGP10.phx.gbl>
Subject: Re: Collation Confusion
Date: Thu, 24 Jun 2004 13:08:24 -0400
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
Message-ID: <uAyDd3gWEHA.1468@.TK2MSFTNGP10.phx.gbl>
Newsgroups: microsoft.public.sqlserver.server
NNTP-Posting-Host: firewall.getconnected.com 207.31.238.50
Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA06.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGX
A01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:347579
X-Tomcat-NG: microsoft.public.sqlserver.server
Code page 1
"Mario" <someone.else@.microsoft.com> wrote in message
news:O3bumugWEHA.1368@.TK2MSFTNGP10.phx.gbl...
> Greetings!
> I'm trying to install SQL Server 2000 (Standard edition) on a new server
to
> mirror the version on an older server. The trouble I'm having is with
> identifying the settings I need in order to match collations.
> The instance of SQL Server on the old server has a collation described
as
> 'SQL_Latin1_General_CP1_CI_AS'. I realise that 'CI' and 'AS' refer to
> case-insensitive and accent-sensitive respectively, but what does 'CP1'
> relate to?
> I've searched through various resources but they all seem to avoid
> describing that one crucial bit of information! Can anyone help?
>