Data types FIREBIRD
TIPOS DE DATOS
|
|
BIGINT |
Integer, 64 bits (-2 x 1063 hasta 2 x 1063 -1) |
CHAR(n) | Cadena de N caracteres. |
DATE | Entero de 32 bits. 01-01-100 to 31-12-9999 |
DECIMAL (precision [,scale]) |
Decimal (Precisión: 1-18, escala: 1-18) DECIMAL(8,3)=ppppp.sss |
DOUBLE PRECICION | Punto Flotante de 64 bits 2.225 x 10-308 hasta 1.797 x 10308 |
FLOAT | Punto Flotante de 32 bits 1.175 x 10-38 hasta 3.402 x 1038 |
INTEGER | Entero de 32 bits, con signo -2.147.483.648 hasta 2.147.483.647 |
NUMERIC (precision [,scale]) |
Igual que DECIMAL (Precision [,scale]) |
SMALLINT | Entero de 16 bits ( -32.768 hasta 32.767 ) |
TIME | Entero de 32 bits 0:00:00 hasta 23:59:59.9999 |
TIMESTAMP | Entero 64 bits. |
VARCHAR(n) | Cadena de n caracteres (0 to 32.765 bytes). Charset character size determines the maximum number of character that can fit in 32k. |
BLOB | Variable. Dynamically sizable data type for storing large data such as graphics, text, and digitized voice. Blob. Blob subtype describes Blob contents. |