Creates a new collation, based on an existing collation.
A new collation is created. A collation is always based on an existing collation, i.e. the new collation
collation-name-1is based on the already existing collation
collation-name-2. If the
CREATE COLLATIONstatement has a
delta-stringis appended to the definition of the collation specified in the
By omitting the
CREATE COLLATIONstatement can be used to create copies of already existing collations.
See Tailorings for information about the
Any ident, who owns a schema, is authorized to create collations.
Usage privilege on the collation is granted to
This example will create a Basque collation based on
Ñ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]'
SQL-2016 Features outside core Feature F690, "Collation support" support for CREATE COLLATION statement. Mimer SQL extension The syntax with USING delta-string is a Mimer SQL extension.The SQL-2016 syntax contains a FOR <character set> clause, which is not supported in Mimer SQL.
Mimer Information Technology AB
Phone: +46 18 780 92 00