MS SQL Server ODBC - Sort order

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Sort order

Hung Le

2005-05-30, 11:23 am

I have a column in table (primary key) which has 2 rows:
'AAAA'
'~~~' in MMSQL 7.0 when i use select * from the table order by .... the
query result will be
'AAAA'
'~~~~'
but when I converted the database to SQL 2000 the result will return
'~~~~'
'AAAAA'.
I tried to change collations and sort order but no luck.

in SQL 7.0 when I type in sp_helpsort the Query return:
Character set = 1, iso_1
ISO 8859-1(Latin01) - Western European 8 - bit
character set.
Sort Order = 50, bin_ISO 8859-1 (Latin 1) character set characters, in order
Can anyone tell me how to correct the problem ?

Thanks

Hungle

Sponsored Links