Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sort Order 50?
- Thread starter soy4soy
- Start date
- Thread starter
- #2
I have many SQL servers. One of them had a hard drive crash. I have backups of all the databases, but the SQL installation seems to be corrupt.
I have replaced all the files, and am able to use rebuildm.exe to get my server back, but when I try to restore my backups, it tells me that my sort order of 50 in the database is not cool with my sort order of 80 on the server.
Below, the character sets appear to be different, but I cannot find the Western European 8-bit character set in my server. The only character set that is close is 1250, Central European Character set. Do you have any idea how I can find the correct one or just set it manually?
Here are my sp_helpsort results:
Downed Server sp_helpsort results:
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 { | } ~ €
‚ „ … † ‡ ‰ Š ‹ Ś Ť Ž Ź ‘ ’ “ ” • – — ™ š › ś ť ž ź ˇ ˘ Ł ¤ Ą
¦ § ¨ © Ş « ¬ ® Ż ° ± ˛ ł ´ µ ¶ · ¸ ą ş » Ľ ˝ ľ ż Ŕ Á Â Ă Ä Ĺ
Ć Ç Č É Ę Ë Ě Í Î Ď Đ Ń Ň Ó Ô Ő Ö × Ř Ů Ú Ű Ü Ý Ţ ß ŕ á â ă ä ĺ
ć ç č é ę ë ě í î ď đ ń ň ó ô ő ö ÷ ř ů ú ű ü ý ţ ˙
Good server sp_helpsort results:
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
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 { | } ~
¡ ¢ £ ¤ ¥ ¦ § ¨ © ª « ¬ ® ¯ ° ± ² ³ ´ µ ¶ · ¸ ¹ º » ¼ ½ ¾ ¿ À
Á Â Ã Ä Å Æ Ç È É Ê Ë Ì Í Î Ï Ð Ñ Ò Ó Ô Õ Ö × Ø Ù Ú Û Ü Ý Þ ß à
á â ã ä å æ ç è é ê ë ì í î ï ð ñ ò ó ô õ ö ÷ ø ù ú û ü ý þ ÿ
I have replaced all the files, and am able to use rebuildm.exe to get my server back, but when I try to restore my backups, it tells me that my sort order of 50 in the database is not cool with my sort order of 80 on the server.
Below, the character sets appear to be different, but I cannot find the Western European 8-bit character set in my server. The only character set that is close is 1250, Central European Character set. Do you have any idea how I can find the correct one or just set it manually?
Here are my sp_helpsort results:
Downed Server sp_helpsort results:
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 { | } ~ €
‚ „ … † ‡ ‰ Š ‹ Ś Ť Ž Ź ‘ ’ “ ” • – — ™ š › ś ť ž ź ˇ ˘ Ł ¤ Ą
¦ § ¨ © Ş « ¬ ® Ż ° ± ˛ ł ´ µ ¶ · ¸ ą ş » Ľ ˝ ľ ż Ŕ Á Â Ă Ä Ĺ
Ć Ç Č É Ę Ë Ě Í Î Ď Đ Ń Ň Ó Ô Ő Ö × Ř Ů Ú Ű Ü Ý Ţ ß ŕ á â ă ä ĺ
ć ç č é ę ë ě í î ď đ ń ň ó ô ő ö ÷ ř ů ú ű ü ý ţ ˙
Good server sp_helpsort results:
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
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 { | } ~
¡ ¢ £ ¤ ¥ ¦ § ¨ © ª « ¬ ® ¯ ° ± ² ³ ´ µ ¶ · ¸ ¹ º » ¼ ½ ¾ ¿ À
Á Â Ã Ä Å Æ Ç È É Ê Ë Ì Í Î Ï Ð Ñ Ò Ó Ô Õ Ö × Ø Ù Ú Û Ü Ý Þ ß à
á â ã ä å æ ç è é ê ë ì í î ï ð ñ ò ó ô õ ö ÷ ø ù ú û ü ý þ ÿ
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question