This topic 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 Compile, make available, and apply 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.