Sunday, March 25, 2012

Collation equivalence

Hello everyone,
I have a SQL 7 server and I am trying to find the equivalent collation in
SQL Server 2000. Output of sp_helpsort on the SQL 7:
Unicode data sorting
--
Locale ID = 33280
case sensitive
Sort Order Description
---
Character Set = 1, iso_1
ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Sort Order = 50, bin_iso_1
Binary Sort Order for the ISO 8859-1 (Latin 1) Character Set
Anyone knows where I can find out this information?
Thank you all!
--
--
Sasan Saidi
MSc in CS, MCSE4, IBM Certified MQ 5.3 Administrator
Senior DBAMy guess is Latin1_General_BIN
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Sasan Saidi" <SasanSaidi@.discussions.microsoft.com> wrote in message
news:5E7997A5-5CF2-4CB0-A5B3-A62765F687A2@.microsoft.com...
> Hello everyone,
> I have a SQL 7 server and I am trying to find the equivalent collation in
> SQL Server 2000. Output of sp_helpsort on the SQL 7:
> Unicode data sorting
> --
> Locale ID = 33280
> case sensitive
>
> Sort Order Description
> ---
> Character Set = 1, iso_1
> ISO 8859-1 (Latin-1) - Western European 8-bit character set.
> Sort Order = 50, bin_iso_1
> Binary Sort Order for the ISO 8859-1 (Latin 1) Character Set
> Anyone knows where I can find out this information?
> Thank you all!
> --
> --
> Sasan Saidi
> MSc in CS, MCSE4, IBM Certified MQ 5.3 Administrator
> Senior DBA

No comments:

Post a Comment