Change the Default Sort Order

SAP ASE can have only one default sort order, which is the collating sequence it uses to order data.

When you consider changing the sort order for character data on a particular SAP ASE, keep in mind that all of your organization’s SAP ASEs 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.