Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


CREATE COLLATION


Creates a new collation, based on an existing collation.



Usage

Embedded/Interactive/ODBC/JDBC.

Description

A new collation is created. A collation is always based on an existing collation, i.e. the new collation collation-name-1 is based on the already existing collation collation-name-2. If the CREATE COLLATION statement has a USING clause, the delta-string is appended to the definition of the collation specified in the FROM clause.

By omitting the USING clause, the CREATE COLLATION statement can be used to create copies of already existing collations.

See Tailorings for information about the delta-string.

Restrictions

Any ident, who owns a schema, is authorized to create collations.

Notes

Usage privilege on the collation is granted to PUBLIC.

Examples

This example will create a Basque collation based on EOR_1, where is treated as a separate letter, sorted directly after N:

 CREATE COLLATION basque FROM eor_1 USING '& N <  <<< '
 

The following example will create an English collation based on ENGLISH_1, which also sorts numerical data:

 CREATE COLLATION english_numeric_1 FROM english_1 USING '[NUMERIC ON]'

Standard Compliance

Standard
Compliance
Comments
SQL-2003
Features outside core
Feature F691, "Character sets and collations" support for CREATE COLLATION statement.

Mimer SQL extension
The syntax with USING delta-string is a Mimer SQL extension.
The syntax in SQL-2003 contains a FOR <character set> clause which is not supported in Mimer SQL.


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX