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,
Cdric Del Nibbio
MCP since 2003
MCAD .NET
MCTS SQL Server 2005
On 15 dc, 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?
> Thank for any help.
|||Hi thank you,
This is the only difference? nothig about location or language?
Thank again
"Cédric Del Nibbio" wrote:

> 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édric Del Nibbio
> MCP since 2003
> MCAD .NET
> MCTS SQL Server 2005
>
> On 15 déc, 15:24, sqlextreme <sqlextr...@.discussions.microsoft.com>
> wrote:
>
|||Well, as far as I know, the two standards are kept for compatibility
reasons.
Both collations seem to allow every western europe character sets.
Using french character sets and english ones, I've never noticed any
problem in either one or the other collation.
However, I know that, according to the localization, you should get the
"-" before the "a" or after the "z"... Thus, the choice is linked to
the localization...
As an example, in France, we consider the "-" as a space so before the
"a".
Hope this will help you.
Cdric Del Nibbio
MCP since 2003
MCAD .NET
MCTS SQL Server 2005
sqlextreme a crit :
[vbcol=seagreen]
> Hi thank you,
> This is the only difference? nothig about location or language?
> Thank again
> "Cdric Del Nibbio" wrote:
|||Thank you very much for any help.
"sqlextreme" wrote:
[vbcol=seagreen]
> Hi thank you,
> This is the only difference? nothig about location or language?
> Thank again
> "Cédric Del Nibbio" wrote: