Re: Collation Confusion
From: Bart Duncan [MSFT] (bartd_at_online.microsoft.com)
Date: 06/25/04
- Next message: Aaron [SQL Server MVP]: "Re: order by slowing me down X 40"
- Previous message: ChrisR: "order by slowing me down X 40"
- In reply to: Adam Machanic: "Re: Collation Confusion"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 25 Jun 2004 22:12:16 GMT
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?
>
>
- Next message: Aaron [SQL Server MVP]: "Re: order by slowing me down X 40"
- Previous message: ChrisR: "order by slowing me down X 40"
- In reply to: Adam Machanic: "Re: Collation Confusion"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
