Subject Re: [firebird-support] FireBird 2.5 How can i create 1 byte (0-255) column?
Author Markus Ostenried
On Wed, Apr 3, 2013 at 5:25 PM, Ann Harrison <aharrison@...>wrote:

> **
> 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.

Out of curiosity:
Can the "sandwich problem" be controlled via "alter position"? IOW does
column position affect the record layout on disk?

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