Changing SQL Sort Order
Changing SQL Sort Order
Changing SQL Sort
Order
After you have MS SQL Server installed, you need to check the LocaleID and Sort Order ID.
Run the SQL Query Analyzer and execute the following code:
exec sp_helpsort
The result should be something like this:
Unicode data sorting
----------------------
Locale ID = 1060
case insensitive, kana type insensitive, width insensitive
Sort Order Description
-----------------------------------------------------------------
Character Set = 4, cp1250
Code page 1250
Sort Order = 96, slvnc
Slovenian dictionary case-insensitive sort order for use with
code page 1250
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 Ż=ż ?=? ?=Y
Rebuilding MS SQL Server 7.0
The LocaleID and Sort Order ID cannot be changed after installation, except
by rebuilding the Server.
To rebuild the Server:
- Copy all files from SQL Server's Data folder (e.g.: C:\MSSQL7\DATA) to
another folder.
- Run rebuildm.exe in the Binn folder (e.g.: C:\MSSQL7\BINN\REBUILDM.EXE)
for the Source Directory, select the folder to which you have copied
the files from step 1;
for Character Set, Sort Order, and Unicode
Collation select the character set Character Set: 1250 Central European,
and sort order Slovenian dictionary order, case-insensitive,
the Unicode Collation is selected automatically, after you set a sort order.
- Click Rebuild.
- Close the program after rebuilding has finished, and start the server.