Discontinued Collations in SQL 2000

The collation LATIN1_General_BIN existed in SQL7 but is
not available in SQL2000. Which collation in SQL2000
would be the most appropriate replacement? We have
existing applications using this collation, and are stuck
at how to implement an upgrade path from 7 to 2000.
Thank you,
BillIn 2be501c37976$056ae820$a601280a@.phx.gbl, Bill Kenworthy typed:
> The collation LATIN1_General_BIN existed in SQL7 but is
> not available in SQL2000.
Sorry this is wrong, please see BOL:
"Windows Collation Name"
"SQL Collation Name"
--
Olaf|||Bill,
> The collation LATIN1_General_BIN existed in SQL7 but is
> not available in SQL2000
Not true.Try this query...
SELECT *
FROM ::fn_helpcollations()
WHERE [name] ='LATIN1_General_BIN'
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Bill Kenworthy" <jakesfather@.microsoft.com> wrote in message
news:2be501c37976$056ae820$a601280a@.phx.gbl...
> The collation LATIN1_General_BIN existed in SQL7 but is
> not available in SQL2000. Which collation in SQL2000
> would be the most appropriate replacement? We have
> existing applications using this collation, and are stuck
> at how to implement an upgrade path from 7 to 2000.
> Thank you,
> Bill