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 Internal Code 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 Internationalize ABL Applications for more information about collations.