Release 10.1A: OpenEdge Data Management:
Database Administration

> ## Collation Table (-cpcoll)

> Operating system and syntax | UNIX Windows | `-cpcoll` `tablename`
> Use with | Maximum value | Minimum value | Single-user default | Multi-user default
> CS, DBS | – | – | Basic | Basic

> ``tablename``

> The name of a collation table within the `convmap.cp` file.

> Use Collation Table (-`cpcoll`) to identify a collation table to be used with the code page in memory. The code page is specified by the Internal Code Page (-`cpinternal`) parameter.

> The collation rules that you specify are used to compare characters and sort records if a `BY` clause cannot be satisfied by an index. The collation rules specified with the -`cpcoll` parameter take precedence over the collation specified for any database accessed during the session, except when pre-existing indexes are used or modified. When you update or rebuild a database’s indexes, the collation rules originally defined for that database are used.

> If you do not use -`cpcoll`, the language collation rules defined for the first database on the command line are used. If you do not specify a database on the command line, collation rules with the name “basic” are used.

> To retrieve the value of this startup parameter at run time, use the `SESSION` System handle.

> See OpenEdge Development: Internationalizing Applications for more information on collation tables.

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