Adaptive Server can have only one default sort order, the collating sequence it uses to order data. When you consider changing the sort order for character data on a particular Adaptive Server, keep this in mind: all of your organization’s Adaptive Servers should have the same sort order. A single sort order enforces consistency and makes distributed processing easier to administer.
You may have to rebuild your indexes after changing the default sort order. For more information, see “Reconfiguring the character set, sort order, or message language”.
