SQL Guide : Data types : Character data types
  
Character data types
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
See also
Data types