collation question

23 Mar 2005 9:27 PM

A.G.

Hello

We used MSSQL 2000 ENG - enterprise edition on a Windows 2K SP3 server ENG.

What are differences between SQL_Latin1_General_CP1_CI_AS collation
and Latin1_General_CI_AS collation ?
If I compare with COLLATIONPROPERTY function, results are equals.

Is it possible to install an instance with SQL_Latin1_General_CP1_CI_AS
collation ?
How to dow ?

Thanks.

Alain

4 Apr 2005 4:19 PM

Bart Duncan [MSFT]

> What are differences between SQL_Latin1_General_CP1_CI_AS collation
> and Latin1_General_CI_AS collation ?

They compare non-Unicode (varchar/char) data using different rules. The
Windows collation (Latin1_General_CI_AS) converts all non-Unicode data to
Unicode and then uses the same Unicode string comparison rules that it
uses for Unicode data. The benefit is that consistent rules are used for
both Unicode and non-Unicode string comparisons. The SQL collation
(SQL_Latin1_General_CP1_CI_AS) uses legacy SQL "sort order" rules to
compare non-Unicode data, and a different set of sorting rules for
Unicode data (the same Latin1_General rules that are used by
Latin1_General_CI_AS). The benefit of this is backwards compatibility
with older applications that may rely on the legacy SQL sort order for
non-Unicode data.

> Is it possible to install an instance with
SQL_Latin1_General_CP1_CI_AS
> collation ?

Yes. Do an advanced setup, and on the collation selection dialog click
the "SQL collations" radio button at the bottom of the form, then select
"Dictionary order, case insensitive for use with code page 1252". For
an existing instance, run REBUILDM.EXE and select the same.

Bart
------------
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.

--------------------
Thread-Topic: collation question
thread-index: AcUv7xA8D1swDrfPQriTPAu9nhc9mQ==
X-WBNR-Posting-Host: 213.56.154.227

From: "=?Utf-8?B?QS5HLg==?=" <A*@discussions.microsoft.com>

Subject: collation question
Date: Wed, 23 Mar 2005 13:27:06 -0800
Lines: 17
Message-ID: <435980C5-2967-4A89-87E0-E3C6DE18F***@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.sqlserver.server
Path: TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.server:383050
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
X-Tomcat-NG: microsoft.public.sqlserver.server

Hello

We used MSSQL 2000 ENG - enterprise edition on a Windows 2K SP3 server
ENG.

What are differences between SQL_Latin1_General_CP1_CI_AS collation
and Latin1_General_CI_AS collation ?
If I compare with COLLATIONPROPERTY function, results are equals.

Is it possible to install an instance with SQL_Latin1_General_CP1_CI_AS
collation ?
How to dow ?

Thanks.

Alain