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 |