1.1

Table 8: Explicit conversions between source types and target types for SQL data types
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-------YBOOLEAN
-----------YYYYYYYY-SMALLINT
-----------YYYYYYYY-INTEGER
-----------YYYYYYYY-BIGINT
-----------YYYYYYYY-DECIMAL
------------YYYYYYY-REAL
------------YYYYYYY-DOUBLE
------------YYYYYYY-FLOAT
-YYY-Y---YYY---YYYYYCHAR
-YYY-Y---YYY---YYYYYVARCHAR
-----Y---YYY-------YLONG VARCHAR
----YYYYY-----------CHAR FOR BIT
DATA
----YYYYY-----------VARCHAR FOR BIT
DATA
----YYYYY-----------LONG VARCHAR
FOR BIT DATA
vFabric SQLFire User's Guide544
vFabric SQLFire Reference