Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site



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:

Character class
A ... Z, a ... z
0 1 2 3 4 5 6 7 8 9
Letters and digits
White-space characters (ASCII HEX-values 09 to 0D, or 20, i.e. <TAB>, <LF>, <VT>, <FF>, <CR> or <SP>)
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.

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
Mimer SQL Reference Manual TOC PREV NEXT INDEX