Release 10.1A: OpenEdge Development:
Internationalizing Applications

> ## Creating an empty database in a particular code page

> Here is another technique for producing an empty database in a particular code page. The technique is included here for completeness.

> | To create an empty database with a code page:

> 1. Create an empty database, using the OpenEdge Data Dictionary utility.

> 2. Within the OpenEdge distribution, select the `DLC/prolang` directory for the target locale.

> For example, the `DLC/prolang/cze` directory contains files used for Czech databases, while the `DLC/prolang/utf` directory contains files used for Unicode databases.

> 3. Within the `DLC/prolang` directory you selected, select the collation data definition (`.df`) file whose name corresponds to the target locale.

> These `.df` files define database collations (as opposed to `.df` files that define database schemas). For example, the `DLC/prolang/cze` directory contains the following collation data definition files:

> - `cze1250.df`, associated with the CZECH collation of code page 1250.
> - `cze852.df`, associated with the CZECH collation of code page 852.
> - `cze8859.df`, associated with the CZECH collation of code page ISO8859-1.
> Note: The `DLC/prolang/utf` directory contains the collation data definition files for the International Components for Unicode (ICU) collations (such as `ICU-cs.df` used for Czech databases).

> 4. Confirm the collation name of the `.df` file you selected in Step 3 by viewing its contents using a text editor. Search for the `COLLATION-NAME` keyword. The character string that follows is the name of the `.df` file’s collation.

> 5. Load the `.df` file whose collation name you confirmed in Step 4 into the empty database you created in Step 1 using the following steps:

> 1. Using the Data Administration tool, choose Admin Load Data and Definitions (`.df` file). The Load Data Definitions dialog box appears.
> 2. Enter the name of the data definition file into the Input File field, then choose OK.
> Note: The Data Administration tool calls `.df` files collation tables. The default is `_tran.df`, which contains the UTF-8 BASIC collation.

> 6. Rebuild the database’s indexes by running the `PROUTIL` utility with the `IDXBUILD` qualifier. The syntax is:

> Syntax
>     proutil db-name -C idxbuild all
>       -cpinternal internal-code-page
>       -cpstream stream-code-page

> For the complete syntax of the `PROUTIL` utility, see OpenEdge Data Management: Database Administration .

> The empty database is now associated with the desired code page.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095