Online Documentation for SQL Manager for PostgreSQL

Creating/editing collation


Use the Operator tab of Operator Editor to create/edit an operator and specify its definition.

 

Collations

 

Name

The name of the collation. The collation name can be schema-qualified. If it is not, the collation is defined in the current schema. The collation name must be unique within that schema.

 

Locale

This is a shortcut for setting LC_COLLATE and LC_CTYPE at once. If you specify this, you cannot specify either of those parameters.

 

Collation order

Use the specified operating system locale for the LC_COLLATE locale category. The locale must be applicable to the current database encoding.

 

Character classification

Use the specified operating system locale for the LC_CTYPE locale category. The locale must be applicable to the current database encoding.

 

Existing collation to copy from

The name of an existing collation to copy from. The new collation will have the same properties as the existing one, but it will be an independent object.