Subject Re: [firebird-support] FireBird 2.5 How can i create 1 byte (0-255) column?
Author Ann Harrison
On Sun, Mar 31, 2013 at 11:23 AM, wan30032 <wan30032@...> wrote:

> hello,now i used type is smallint.
> but there are more than 4,000,000,000 records.
> so i want to change with like ms sql tinyint.
I think what you want is :

CHAR[1] Character Set Octets

Don't use VARCHAR[1] - that will make each one three bytes long. And be
careful of the layout of your records. For example, if you sandwich your
CHAR[1] between two integer columns, you'll get three bytes of padding so
the integers align on natural boundaries.

Good luck,


[Non-text portions of this message have been removed]