The manual process to change the sort order is:
Do the following steps first:
Make sure the environment variable (or logical name) LANG is not defined.
Set the environment variable (or logical name) SYBASE.
Login to Adaptive Server and make sure the default database for user “sa” is master:
1> select dbname, name from master..syslogins where name = "sa" 2> go
dbname name ----------- ------------------ master sa
Make the users aware that Adaptive Server will be going down.
If you do not already know the file name for the sort order you want to load, go to “How to Find a Sort Order File Name”.
Load the sort order or additional character set you want into syscharsets. Refer to “How to Load a Sort Order or Additional Character Set” for instructions.
Determine the value for sort order ID if you plan to change the sort order. Refer to “How to Find a Sort Order ID” for instructions.
Determine the value for character set ID if you plan to change the default character set. Refer to “How to Find a Character Set ID” for instructions.
If you planned to change the default character set, do it now. Refer to “How to Change the Default Character Set” for instructions.
If you planned to change the sort order, do it now. Refer to “How to Change the Sort Order” for instructions.
Before proceeding, make sure no one is actively using Adaptive Server.
Shut down Adaptive Server.
Restart Adaptive Server. If you changed the sort order, Adaptive Server will make a number of changes at this time. Refer to “Recovery After Reconfiguration” in the System Administration Guide for details about what Adaptive Server does during this database recovery. Look at the Adaptive Server error log to make sure no problems have occurred.
When Adaptive Server has finished the changes related to the changed sort order, it automatically shuts down.
Restart Adaptive Server.
Confirm the change by running sp_helpsort or looking at the end of the error log.
For example:
1> sp_helpsort 2> go
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 { | } ~
á â ã ä å æ ç è é ê ë ì í î ï d ñ ò ó ô õ ö / ø ù ú û ü y p
.
.
If the sort order did not change:
Use sp_configure to return to the old values for sort order ID and default character set ID as in steps 6 and 7 above.
Study the error log to determine why the change failed.
Fix the problem that caused the change to fail.
Try again, starting at step 6 above.
Refer to “If You Changed the Sort Order or Default Character Set” in the System Administration Guide and do the steps described there. It is very important that you do these steps to guarantee the integrity of your data.
You are now finished changing your sort order or default character set.
The following procedures are referenced in this “Manual Process”section.
