Data type
|
Size
|
Precision
|
Scale
|
Length
|
Display size
|
---|---|---|---|---|---|
CHARACTER CHAR
|
2 G - 1*
(2147483647)
|
DEFLEN
|
N/A
|
DEFLEN
|
DEFLEN
|
WCHAR
NATIONAL CHARACTER
NATIONAL CHAR
NCHAR
|
2 G - 1*
(2147483647)
|
DEFLEN
|
N/A
|
DEFLEN
|
DEFLEN
|
VARCHAR
CHARACTER VARYING
CHAR VARYING
|
2 G - 1**
(2147483647)
|
DEFLEN
|
N/A
|
DEFLEN
|
DEFLEN
|
WVARCHAR
NATIONAL VARCHAR
NCHAR VARYING
NVARCHAR
|
2 G - 1**
(2147483647)
|
DEFLEN
|
N/A
|
DEFLEN
|
DEFLEN
|
LONG VARCHAR
CHARACTER LARGE OBJECT
CHAR LARGE OBJECT
CLOB
|
2G-1
(2147483647)
|
MAXLEN
|
N/A
|
MAXLEN
|
MAXLEN
|
LONG WVARCHAR
LONG NATIONAL VARCHAR
NCHAR LARGE OBJECT
NCLOB
|
2G-1 (2147483647)
|
MAXLEN
|
N/A
|
MAXLEN
|
MAXLEN
|
Note * default is 1 ** default is 254
|