Create an empty database in a particular code page
Print
- Last Updated: February 11, 2026
- 2 minute read
- OpenEdge
- Documentation
This topic describes a technique for producing an empty database in a particular code page, which is included here for completeness.
To create an empty database with a code page:
- Create an empty database, using the OpenEdge Data Dictionary utility.
-
Within the OpenEdge distribution, select the
OpenEdge/prolang directory for the target locale.For example, the
OpenEdge/prolang/cze directory contains files used for Czech databases, while theOpenEdge/prolang/utf directory contains files used for Unicode databases. -
Within the
OpenEdge/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, theOpenEdge/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: TheOpenEdge/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). -
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-NAMEkeyword. The character string that follows is the name of the .df file's collation. -
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:
- Using the Data Administration tool, choose Admin > Load Data and Definitions (.df file). The Load Data Definitions dialog box appears.
-
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.
-
Rebuild all the database's indexes by running the
PROUTILutility with theIDXBUILDqualifier. The syntax is:proutil db-name -C idxbuild all -cpinternal internal-code-page -cpstream stream-code-pageFor the complete syntax of the
PROUTILutility, see Manage the OpenEdge Database.