Characters

www.mimer.com/developer

Characters

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

Description

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.

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.

Character class	Description
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

Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se