Tipo de dato | Ejemplos | Tamaño |
---|---|---|
CHAR |
ALPHANUMERIC
CHARACTER
CHARACTER VARYING
CHAR
CHAR VARYING
CHARACTER
CHARACTER VARYING
NCHAR
STRING
TEXT(n)
VARCHAR
|
2 bytes por carácter. |
TEXT | LONGCHAR
LONGTEXT
MEMO
NOTE
NTEXT
|
|
BINARY | VARBINARY BINARY VARYING BIT VARYING |
1 byte por carácter |
BIT | BOOLEAN LOGICAL LOGICAL1 YESNO |
1 byte |
TINYINT | INTEGER1 BYTE |
1 byte |
MONEY | CURRENCY | 8 bytes |
DATETIME | DATE TIME |
8 bytes |
DECIMAL | NUMERIC DEC |
17 bytes |
REAL | SINGLE FLOAT4 IEEESINGLE |
4 bytes |
FLOAT |
DOUBLE FLOAT8 NUMBER |
8 bytes |
SMALLINT | SHORT |
2 bytes |
INTEGER | LONG INT INTEGER4 |
4 bytes |