Modern_Spanish Vs Latin1_General

Could anyone tell me what's the difference between a Latin1_General CI AS and a Modern_Spanish CI AS collation ? I know both use the 1252 character set and thus it confuses me about what could be the difference between them.

Thanks a lot !
Best regards,
Alan

Alan,

These two collations use the same character set, however they

compare and sort according to different rules. To give one example,

in Modern_Spanish, the characters n and ? are considered different

letters. In Latin1_General, one is an accented version of the other.

This example shows that difference. The first select query returns

one row, but the second returns two.

create table T (

latin1 varchar(100) collate Latin1_General_CS_AI,

modspan varchar(100) collate Modern_Spanish_CS_AI

)

go

insert into T values ('ba?o', 'ba?o')

insert into T values ('bano', 'bano')

go

select latin1, count(*) as ct from T

group by latin1

select modspan, count(*) as ct from T

group by modspan

go

drop table T

-- Steve Kass

-- Drew University

AlanK@.discussions.microsoft.com wrote:

> Could anyone tell me what's the difference between a Latin1_General CI

> AS and a Modern_Spanish CI AS collation ? I know both use the 1252

> character set and thus it confuses me about what could be the difference

> between them.

>

> Thanks a lot !

> Best regards,

> Alan

>

|||Thanks a lot Steve.
Do you know if there's a link or help where you can see those "Collation rules" such as the one you mention ? I've checked the help on Collations from Microsoft but couldn't find an analysis on the differences between each of them, or the rules that each apply.

Best regards,
Alan.|||

I'm afraid I don't. Some of the rules are fairly obscure, also,

such as when two-character combinations are considered a single

letter (Hungarian Sz, for example). Sorry!

SK

AlanK@.discussions.microsoft.com wrote:

> Thanks a lot Steve.

> Do you know if there's a link or help where you can see those "Collation

> rules" such as the one you mention ? I've checked the help on Collations

> from Microsoft but couldn't find an analysis on the differences between

> each of them, or the rules that each apply.

>

> Best regards,

> Alan.

>