This section summarizes the steps to take before and after changing Adaptive Server’s default character set, sort order, or message language. For procedures on how to configure the character set, sort order, or message language for a new server, see the configuration documentation for your platform.
If your data does not have to be converted to a new character set and both the old and the new character sets use binary sort order you can use a database dump. You can restore your database from backups that were made before the character set was reconfigured.
Back up all databases in Adaptive Server both before
and after you change character sets or sort orders.
Usually, you cannot reload your data from a database dump when you have reconfigured the default character set and sort order.
If the following is true, use bcp to copy the data out of and into your databases.
If a database contains character data, and you want the data to be converted to a new character set. Do not load a database dump of the data into an Adaptive Server with the new default character set. Adaptive Server interprets the data loaded as if it is in the new character set, and the data will be corrupted.
If you are changing only the default sort order and not the default character set. You cannot load a database from a dump that was performed before you changed the sort order. If you attempt to do so, an error message appears, and the load is aborted.
You change the default character set, and either the old or the new sort order is not binary. You cannot load a database dump that was made before you changed the character set.
