Subject Re: [firebird-support] unsigned datatypes
Author Ann W. Harrison
Elahn,


> unsigned byte : storage length = 1 byte
> unsigned word : storage length = 2 bytes
> unsigned longword : storage length = 4 bytes
> unsigned int64 : storage length = 8 bytes
>
>This would help me create smaller database files, which would be very
>useful, as I have a LOT of data to store.

Firebird doesn't recognize unsigned integers. The signed equivalents are
char(1), short, long, and int64. The new SQL standard may recognize
unsigned integers but the SQL-92 did not. Depending on the nature of the
data, you might find that arrays give you more density than fully
normalized tables.

Regards,


Ann