Converting an OpenEdge database to UTF-8 using dump and load

This section describes the steps to convert an OpenEdge database to UTF-8 using dump and load.

To convert an OpenEdge database to UTF-8 using the dump and load utilities:

Caution: Before beginning, back up your database.

Do not use binary dump and load.

1. Dump the schema and data of the existing database using the Data Administration utility. (From the Procedure Editor main menu, select Tools > Data Administration > Admin > Dump Data and Definitions.)

2. Create a new, empty UTF-8 database using the syntax for your specific operating system:

Windows syntax	prodb database-name %DLC%\prolang\utf\empty.db
UNIX syntax	prodb database-name $DLC/prolang/utf/empty.db

Note: OpenEdge loads the UTF-8 BASIC collation (the _tran.df collation data definition file) in the empty UTF-8 database automatically and by default.

3. If you want to use an International Components for Unicode (ICU) collation, load the collation data definition (.df) file using the syntax for your specific operating system:

Windows syntax	%DLC%\prolang\utf\filename.df
UNIX syntax	$DLC/prolang/utf/filename.df

ICU collation data definition files are prefixed with "ICU" or "ICU_48" (such as ICU-cs.df used for Czech databases). For more information about character processing, see the README.txt file in the directory OpenEdge/prolang.

4. Compile, store, and apply the UTF-8 word-break rules to the database. For complete instructions, see Compiling, storing, and applying the UTF-8 word-break rulesto a database.

5. Load the schema and data to the database using the Data Administration utility. (From the Procedure Editor main menu, select Tools > Data Administration > Admin > Load Data and Definitions

Note: When the data are loaded, the indexes are automatically rebuilt.