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 Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se