Characters

http://developer.mimer.com

Characters

The character set used by Mimer SQL is ISO 8859-1 (LATIN1) - see Character Sets.

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, double quotation marks, "", or single quotation marks, ', 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