Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


COLLATIONS


The COLLATIONS system view describes each collation to which the current ident, or PUBLIC, has USAGE privilege.

The view includes one row describing the collation named SQL_TEXT which is defined on the character set named SQL_TEXT and is the default collation for that character set.

Column name
Data type
Description
COLLATION_CAT
VARCHAR(128)
The name of the catalog containing the collation.
COLLATION_SCHEM
VARCHAR(128)
The name of the schema containing the collation.
COLLATION_NAME
VARCHAR(128)
Name of the collation.
CHARSET_CAT
VARCHAR(128)
The name of the catalog containing the character set on which the collation is defined.
CHARSET_SCHEM
VARCHAR(128)
The name of the schema containing the character set on which the collation is defined.
CHARSET_NAME
VARCHAR(128)
The name of the character set on which the collation is defined.
PAD_ATTRIBUTE
VARCHAR(20)
One of the following values:
"NO PAD" = the collation has the no pad attribute
"PAD SPACE" = the collation has the pad space attribute.
REMARKS
VARCHAR(254)
May contain descriptive information about the collation.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX