Changing the character set or sort order

To change the charset or sort order:

1. Shut down Adaptive Server using VCS commands.

2. Change the membership mode to native:

   qrmutil -Q quorum_file --membership-mode="native"
   

   Restart a single instance in the cluster manually or with sybcluster.

3. To change the charset, run charset. For example:

   $SYBASE/ASE-15_0/bin/charset -Usa -P nocase.srt utf8
   

4. To change the sort order, reset the default sortorder id configuration parameter. For example:

   isql -Usa -P
   sp_configure 'default sortorder id', 101, 'utf8'
   

5. Shut down the cluster from isql

6. Restart an instance. Adaptive Server reconfigures the characterset and sort order, and shuts down.

7. Change the membership mode back to VCS:

   qrmutil -Q quorum_file --membership-mode='vcs'
   

8. Restart the cluster using VCS commands.