Data type assignments and comparison, sorting, and orderingdata typesassignments and comparisions
Assignments allowed by This table displays valid assignments between data types in .
A "Y" indicates that the assignment is valid.TypesS
M
A
L
L
I
N
TI
N
T
E
G
E
RB
I
G
I
N
TD
E
C
I
M
A
LR
E
A
LD
O
U
B
L
EF
L
O
A
TC
H
A
RV
A
R
C
H
A
RL
O
N
G
V
A
R
C
H
A
RC
H
A
R
F
O
R
B
I
T
D
A
T
AV
A
R
C
H
A
R
F
O
R
B
I
T
D
A
T
AL
O
N
G
V
A
R
C
H
A
R
F
O
R
B
I
T
D
A
T
AC
L
O
BB
L
O
BD
A
T
ET
I
M
ET
I
M
E
S
T
A
M
PX
M
LU
s
e
r
-
d
e
f
i
n
e
d
t
y
p
eSMALL INTYYYYYYY-------------INTEGERYYYYYYY-------------BIGINTYYYYYYY-------------DECIMALYYYYYYY-------------REALYYYYYYY-------------DOUBLEYYYYYYY-------------FLOATYYYYYYY-------------CHAR-------YYY---Y-YYY--VARCHAR-------YYY---Y-YYY--LONG VARCHAR-------YYY---Y------CHAR FOR BIT DATA----------YYY-------VARCHAR FOR BIT DATA----------YYY-------LONG VARCHAR FOR BIT DATA----------YYY-------CLOB-------YYY---Y------BLOB--------------Y-----DATE-------YY------Y----TIME-------YY-------Y---TIMESTAMP-------YY--------Y--XML------------------Y-User-defined type-------------------Y
A value of a user-defined type can be assigned to a value of any supertype of
that user-defined type. However, no explicit casts of user-defined types are
allowed.
Comparisons allowed by DerbyThis table displays
valid comparisons between data types in .
A "Y" indicates that the comparison is allowed.TypesS
M
A
L
L
I
N
TI
N
T
E
G
E
RB
I
G
I
N
TD
E
C
I
M
A
LR
E
A
LD
O
U
B
L
EF
L
O
A
TC
H
A
RV
A
R
C
H
A
RL
O
N
G
V
A
R
C
H
A
RC
H
A
R
F
O
R
B
I
T
D
A
T
AV
A
R
C
H
A
R
F
O
R
B
I
T
D
A
T
AL
O
N
G
V
A
R
C
H
A
R
F
O
R
B
I
T
D
A
T
AC
L
O
BB
L
O
BD
A
T
ET
I
M
ET
I
M
E
S
T
A
M
PX
M
LU
s
e
r
-
d
e
f
i
n
e
d
t
y
p
eSMALL INTYYYYYYY------------INTEGERYYYYYYY------------BIGINTYYYYYYY-------------DECIMALYYYYYYY-------------REALYYYYYYY-------------DOUBLEYYYYYYY-------------FLOATYYYYYYY-------------CHAR-------YY------YYY--VARCHAR-------YY------YYY--LONG VARCHAR--------------------CHAR FOR BIT DATA----------YY--------VARCHAR FOR BIT DATA----------YY--------LONG VARCHAR FOR BIT DATA--------------------CLOB--------------------BLOB--------------------DATE-------YY------Y----TIME-------YY-------Y---TIMESTAMP-------YY--------Y--XML--------------------User-defined type--------------------