Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


Character Sets and Collations


For character data, Mimer SQL uses the character set ISO 8859-1, also known as the Latin1 character set. By default, character data is sorted in the numerical order of their codes according to the ISO8BIT collation.

For national character data, Mimer SQL uses the Unicode character set. By default national character data is sorted according to the UCS_BASIC collation.

It is not possible to add, drop or modify a character set.

Every character set has one default collation.

Character Set
Default Collation
Data Types
 ISO 8859-1
ISO8BIT
CHARACTER
CHARACTER VARYING
CLOB
 UNICODE
UCS_BASIC
NCHAR
NCHAR VARYING
NCLOB

If you want to sort characters in a different way than the default, you can specify a collation at the column level when creating or altering a table or creating a domain. You can also override a collation by using a COLLATE clause in an SQL statement.


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