difference between SQL_Latin1_General_CP1_CI_AS and Latin1_General

Hello
I need to know the difference between SQL_Latin1_General_CP1_CI_AS and
Latin1_General_CI_AS please. which is better?
Thank for any help.Hi,
these two collation are simply different. Collation is an order
classification.
Just try the following to have an idea of one difference between the
two orders :
SELECT case when ('ab' COLLATE SQL_Latin1_General_CP1_CI_AS) > ('a-b'
COLLATE SQL_Latin1_General_CP1_CI_AS) then 0 else 1 end
SELECT case when ('ab' COLLATE Latin1_General_CI_AS) > ('a-b' COLLATE
Latin1_General_CI_AS) then 0 else 1 end
None is better, just the one you need ;).
Enjoy,
C=E9dric Del Nibbio
MCP since 2003
MCAD .NET
MCTS SQL Server 2005
On 15 d=E9c, 15:24, sqlextreme <sqlextr...@.discussions.microsoft.com>
wrote:
> Hello
> I need to know the difference between SQL_Latin1_General_CP1_CI_AS and
> Latin1_General_CI_AS please. which is better?
>=20
> Thank for any help.