BackOffice Products
cancel
Showing results for 
Search instead for 
Did you mean: 

MSSQL 2000 Server

 
Rudin Sven
Occasional Contributor

MSSQL 2000 Server

I need to install a SQL Server a specified character set.
On Oracle we had WE8ISO8859SP1.
Whitch ISO is that on MSSQLserver2000; i can't find one with the same name.

Thanks for any help


Sven
2 REPLIES 2
Jasdev Singh
Esteemed Contributor

Re: MSSQL 2000 Server

Hi Rudin,

Find out SQL Server's default character set sp_helpsort Configure SQL Server's default character set sp_configure "default character set id" Change character setssybinitUpgrade text values after changing character sets dbcc fix_text.

Displays SQL Server's default sort order and character set.

Syntax
sp_helpsort

Examples
sp_helpsort
For Class 1 (single-byte) character sets, sp_helpsort displays the name of the server's default sort order, its character set, and a table of its primary sort values. On a 7-bit terminal, it appears as follows:


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 character set (iso_1). 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 { | } ~ ! " # $ % & ' ( ) * + , - . / 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 { | } ~
On an 8-bit terminal, it appears as follows:

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 character set (iso_1).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 { | } ~ ¡ ¢ £ ¤ ¥ | § ¨ © ª ¬ - (R) ¯ ° 2 3 ´ m ¶ · ¸ 1 º 1/4 1/2 3/4 ¿ à à à à à à à à à à à à à à à à D à à à à à à ´ à à à à à Y P à à á â ã ä å æ ç è é ê ë ì í î ï ñ ò ó ô õ ö ¸ ø ù ú û ü y p ÿ
For a Class 2 (multibyte) character set, the characters are not listed, but a description of the character set is included. For example:

Sort Order Description -----------------------------------------------------------------Character Set = 140, euc_jis Japanese. Extended Unix Code mapping for JIS-X0201 (hankaku katakana) and JIS-X0208 (double byte) roman, kana, and kanji. Class 2 character setSort Order = 50, bin_eucjis Binary sort order for Japanese using the EUC JIS character set as a basis.

Any user can execute sp_helpsort.

Tables Used
master.dbo.syscharsets, master.dbo.syscurconfigs, sysobjects



jasdev

(pls assign points, if the issue resolves)
Rudin Sven
Occasional Contributor

Re: MSSQL 2000 Server

Thanks