1.0

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 581, INTEGER on page 579, BIGINT on page 573, DECIMALSyntax in
CREATE TABLEExample on page 577, NUMERICSyntax in CREATE TABLE on page 580)
• Approximate numeric (FLOATSyntax in CREATE TABLE on page 578, REALExamples on page 580,
DOUBLE PRECISION on page 578)
• string
515
SQL Language Reference