Would a backup/restore change the physical layout to match the logical? -----Original Message----- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Ann Harrison Sent: Wednesday, April 03, 2013 4:54 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] FireBird 2.5 How can i create 1 byte (0-255) column?
On Wed, Apr 3, 2013 at 12:25 PM, Markus Ostenried <mac...@gmail.com> wrote: > > > > > ... 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? No, "alter position" just changes the logical position of the columns - what you see from a SELECT *. The physical layout is determined when the table is defined, and added fields always come last. Good luck, Ann > > > [Non-text portions of this message have been removed] > > > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Resources item on the > main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo! Groups Links > > > > [Non-text portions of this message have been removed] ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links