MSSQL 2000 Server

Rudin Sven — Wed, 01 Mar 2006 09:34:31 GMT

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

Re: MSSQL 2000 Server

Jasdev Singh — Thu, 02 Mar 2006 16:28:45 GMT

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)

Re: MSSQL 2000 Server

Rudin Sven — Thu, 04 Mar 2010 10:18:36 GMT

Thanks

topic Re: MSSQL 2000 Server in BackOffice Products

MSSQL 2000 Server

Re: MSSQL 2000 Server

Re: MSSQL 2000 Server