Collation Table (-cpcoll)

Use Collation Table (-cpcoll) to identify a collation for the AVM to use with the code page in memory. The code page is specified by the InternalCode Page (-cpinternal) parameter.

Operating system and syntax	UNIX / Windows	-cpcoll collation-name
Use with	Maximum value	Minimum value	Single-user default	Multi-user default
Client Session, Database Server	—	—	Basic	Basic

collation-name

The name of a collation table within the convmap.cp file, or the name of a collation in the International Components for Unicode (ICU) library.

The AVM uses the collation rules that you specify 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 the AVM accesses during the session, except when the AVM uses or modifies pre-existing indexes. When you update or rebuild a database's indexes, the AVM uses the collation rules originally defined for that database.

If you do not use -cpcoll, the AVM uses the language collation rules defined for the first database on the command line. If you do not specify a database on the command line, the AVM uses the collation rules with the name "basic."

To retrieve the value of this startup parameter at runtime, use the SESSION system handle.

See OpenEdge Development: Internationalizing Applications for more information on collations.