Try OpenEdge Now
skip to main content
Internationalizing Applications
Using Unicode : Using Unicode with OpenEdge databases : Converting an OpenEdge database to UTF-8 using dump and load
 

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 rules to 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.