solidDB Help : solidDB reference : SQL: Data types : Character data types
  
Character data types
The size limits for character data types apply to both disk-based tables (D-tables) and in-memory tables (M-tables) but all columns must fit within the table row.
▪ The maximum row size for D-tables is 2G - 1.
▪ The maximum row size for M-tables is configurable (default 2M, maximum 32M). In solidDB versions prior to version 200.0 the maximum row size was 32K.
The following table describes the character data types. See SQL: Data types for a description of the column headings.
(* default is 1, ** default is 254)
 
Data type
Size
Precision
Scale
Length
Display size
CHARACTER CHAR
2G - 1*
(2147483647)
DEFLEN
N/A
DEFLEN
DEFLEN
WCHAR
NATIONAL CHARACTER
NATIONAL CHAR
NCHAR
2G - 1*
(2147483647)
DEFLEN
N/A
DEFLEN
DEFLEN
VARCHAR
CHARACTER VARYING
CHAR VARYING
2G - 1**
(2147483647)
DEFLEN
N/A
DEFLEN
DEFLEN
WVARCHAR
NATIONAL VARCHAR
NCHAR VARYING
NVARCHAR
2G - 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
Go up to
SQL: Data types