Subject | Re: [firebird-support] FireBird 2.5 How can i create 1 byte (0-255) column? |
---|---|
Author | Markus Ostenried |
Post date | 2013-04-03T16:25:35Z |
On Wed, Apr 3, 2013 at 5:25 PM, Ann Harrison <aharrison@...>wrote:
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]
> **Out of curiosity:
> 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.
>
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]