Try OpenEdge Now
skip to main content
Database Administration
Reference : Database Startup Parameters : Alphabetical listing of database startup parameters : Collation Table (-cpcoll)
 
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.