SQL Server2000

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hi,

I am upgrading database from SQL Server 6.5 to SQL Server 2000.

In SQL6.5

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

In SQL2000 i choose Latin1_genral and binary sort order,i am getting problems in upgrade.

which option i have to choose in the SQL Server 2000 to make my server binary sort order and case-sensitive.

Thanks, Ravi.

-- Anonymous, February 15, 2002

Answers

Ravi,

The concepts of "Binary order" and "Dictionary order, case- insensitive" are mutually exclusive.

Hope this helps,

Eric

-- Anonymous, February 21, 2002


Moderation questions? read the FAQ