The character set used by Mimer SQL is ISO 8859-1 (LATIN1) - see Character Set.
For the purposes of the syntax rules in SQL, characters may be divided into the following classes:
Letters A ... Z, a ... z Digits 0 1 2 3 4 5 6 7 8 9 Alphanumeric Letters and digits Separators White-space characters (ASCII HEX-values 09 to 0D, or 20, i.e. <TAB>, <LF>, <VT>, <FF>, <CR> or <SP>) Special All characters except letters and digits
Note: The definition of letters is restricted to the English standard alphabet. National characters are treated as special characters.
Certain special characters have particular meanings in SQL statements, for example, delimiters (quotation marks " or apostrophes ') and arithmetic and comparative operators (+ - / * = < > etc.).
The special characters $ and # may, in some circumstances, be used in the same contexts as letters, see Identifiers.
A separator is used to separate keywords, identifiers and literals from each other.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40