Hi!

I am changing from sql7 to sql2k and i would like to be sure i have maintaned the same sort order etc. i had in sql7:


Unicode data sorting
----------------------
Locale ID = 33280

case sensitive


Sort Order Description
------------------------------------------------------------------------------------------------------------------------------------
Character Set = 4, cp1250
Code page 1250
Sort Order = 80, bin_cp1250
Binary Sort Order for the Code Page 1250 Character Set

Characters, in Order
------------------------------------------------------------------------------------------------------------------------------------
! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?
@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _
` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~
_
_



So i think in sql2k i should set:

Polish_BIN

i need to have bin sorting and polish letters.


on collation list:

select * from ::fn_helpcollations()

there is not available:

sql_latin1_general_cp1250_bin

Please let me know if i am right or not.

Thanks in advance


by the way anybody knows how to get the list of ordered characters used by the sql server 2k same as the one extracted from the sql7. standard procedure sp_helpsort was used to receive the result at the start of this message, but for sql2k gives slightly different answer as:

only: Polish, binary sort

?