1.1

X
M
L
T
I
M
E
S
T
A
M
P
T
I
M
E
D
A
T
E
B
L
O
B
C
L
O
B
L
O
N
G
V
A
R
C
H
A
R
F
O
R
B
I
T
D
A
T
A
V
A
R
C
H
A
R
F
O
R
B
I
T
D
A
T
A
C
H
A
R
F
O
R
B
I
T
D
A
T
A
L
O
N
G
V
A
R
C
H
A
R
V
A
R
C
H
A
R
C
H
A
R
F
L
O
A
T
D
O
U
B
L
E
R
E
A
L
D
E
C
I
M
A
L
B
I
G
I
N
T
I
N
T
E
G
E
R
S
M
A
L
L
I
N
T
B
O
O
L
E
A
N
Types
-----Y---YYY-------YCLOB
----Y---------------BLOB
---Y------YY--------DATE
--Y-------YY--------TIME
-YYY------YY--------TIMESTAMP
Y-------------------XML
If a conversion is valid, CASTs are allowed. Size incompatibilities between the source and target types might
cause runtime errors.
Notes
In this discussion, the SQLFire SQL-92 data types are categorized as follows:
• logical
• BOOLEAn
• numeric
• Exact numeric (SMALLINT on page 611, INTEGER on page 609, BIGINT on page 604, DECIMALSyntax in
CREATE TABLEExample on page 607, NUMERICSyntax in CREATE TABLE on page 610)
• Approximate numeric (FLOATSyntax in CREATE TABLE on page 609, REALExamples on page 611,
DOUBLE PRECISION on page 609)
• string
545
SQL Language Reference