Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site



As stated in the previous section, character and national character data is sorted according to specific collations.

A collation, also known as a collating sequence, is a database object containing a set of rules that determines how character strings are compared, searched and alphabetically sorted. The rules in the collation determine whether one character string is less than, equal to or greater than another. A collation also determines how case-sensitivity and accents are handled.

Each collation belongs to a character set.

A collation belonging to a particular character set can only be used to compare or order character values belonging to that character set

Every character set has one default collation.

Character Set
Default Collation
Optional Collations
 ISO 8859-1

Referred to as ISO8BIT in SQL.

swedish - Swedish language-specific sorting rules, case insensitive and accent insensitive.
english - English language-specific sorting rules, case insensitive and accent insensitive.

Referred to as UTF32 in SQL.


You can review copies of these collations by opening the collations.sql file included in your Mimer SQL distribution.

Note: Upright Database Technology AB reserves the right to change the contents of these collations in future releases.

You can specify a different collation for ordering characters when you create or alter a table or create a domain.

If you have specified a collation for a column, the collation is used implicitly in SQL statements.

You only need to explicitly use a collation clause in SQL statements if you want to override the default collation or the collation you specified when creating or altering the table or creating the domain.

In Mimer SQL, a collation belongs to a schema. For more information, see the Mimer SQL User's Manual, chapter 6, Collations.

Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
Mimer SQL Documentation TOC PREV NEXT INDEX