Before you run the installation program to reconfigure Adaptive Server:
Dump all user databases and the master database. If you have made changes to model or sybsystemprocs, dump them also.
Load the Language Module if it is not already loaded (see the configuration documentation for your platform for complete instructions).
If you are changing the Adaptive Server default character set, and your current databases contain non ASCII-7 data, use bcp to copy the existing data out of your databases.
Once you have loaded the Language Module, you can run the Adaptive Server installation program, which allows you to:
Install or remove message languages and character sets included with Adaptive Server
Change the default message language or character set
Select a different sort order
See the configuration documentation for your platform for instructions on using the installation program
Before you change the character set or sort order, Adaptive
Server must have as many open databases as there are databases managed
by the server. If Adaptive Server does not have a sufficient number
of open databases when it is re-started after a change in sort order,
Adaptive Server prints this message to the error log and the server
will revert to the former sort order:
The configuration parameter 'number of open databases' must be at least as large as the number of databases, in order to change the character set or sort order." Re- start Adaptive Server, use sp_configure to increase 'number of open databases' to at least %d, then re- configure the character set or sort order
To reconfigure the language, character set, or sort order, use the sqlloc utility, described in Utility Guide. If you are using Windows, use the Server Config utility, described in Chapter 3, “Default Adaptive Server Configuration,” in the Configuration Guide.
If you installed additional languages but did not change the Adaptive Server character set or sort order, you have completed the reconfiguration process.
If you changed the Adaptive Server default character set, and your current databases contain non ASCII-7 data, copy your data back into your databases, using bcp with the necessary flags to enable conversion.
If you changed the Adaptive Server default sort order or character set, see “Reconfiguring the character set, sort order, or message language”.