February 6, 2003 at 11:24 am
1. If I try to use the data wizard to migrate DB, will it adjust collation, etc?
2. When I install SQL2000, what collation should I choose if sp_helpsort returns following for my current SQL7 sp2.
Unicode data sorting
----------------------
Locale ID = 1033
case insensitive, kana type insensitive, width insensitive
Sort Order Description
------------------------------------------------------------------------------------------------------------------------------------
Character Set = 1, iso_1
ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Sort Order = 52, nocase_iso
Case-insensitive dictionary sort order for use with several We
stern-European languages including English, French, and German
. Uses the ISO 8859-1 character set.
Characters, in Order
------------------------------------------------------------------------------------------------------------------------------------
! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { | }
~ ¡ ¢ £ ¤ ¥ ¦ § ¨ © ª « ¬ ® ¯ ° ± ² ³ ´ µ ¶ · ¸ ¹ º » ¼ ½ ¾
¿ × ÷ 0 1 2 3 4 5 6 7 8 9 A=a À=à Á=á Â=â Ã=ã Ä=ä Å=å Æ=æ B=b C
=c Ç=ç D=d E=e È=è É=é Ê=ê Ë=ë F=f G=g H=h I=i Ì=ì Í=í Î=î Ï=ï J
=j K=k L=l M=m N=n Ñ=ñ O=o Ò=ò Ó=ó Ô=ô Õ=õ Ö=ö Ø=ø P=p Q=q R=r S
=s ß T=t U=u Ù=ù Ú=ú Û=û Ü=ü V=v W=w X=x Y=y Ý=ý ÿ Z=z Ð=ð Þ=þ
February 6, 2003 at 12:41 pm
Hello RAD,
By default it will install collation
'SQL_Latin1_General_CP1_CI_AS'
Hope this helps.
Rearasi
February 6, 2003 at 1:37 pm
The question really was what collation I have to install on SQL2000 to match mine on SQL7 ( see sp_helpsort result above in first message)
February 7, 2003 at 9:38 am
Can someone answer ( see above)?
Thanks!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply