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.
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