: [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
On Thu, Apr 4, 2013 at 3:30 PM, Rick Debay rde...@accessrxs.com wrote:
Would a backup/restore change the physical layout to match the logical?
It could, but it doesn't. A slightly smarter restore would sort the fields
by alignment, recreate the table physically from the most restrictive
On Sun, Mar 31, 2013 at 11:23 AM, wan30032 wan30...@yahoo.com 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
Hello, wan30032!
Sunday, March 31, 2013, 7:23:14 PM, you wrote:
w hello,now i used type is smallint.
w but there are more than 4,000,000,000 records.
w so i want to change with like ms sql tinyint.
I need to say some, against char(1) etc. instead of
smallint
- rows are being compressed in
On Wed, Apr 3, 2013 at 5:25 PM, Ann Harrison aharri...@ibphoenix.comwrote:
**
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]
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
On 31-3-2013 17:23, 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.
For binary data you can use (VAR)CHAR with character set OCTETS. So if
you want to store one byte use: CHAR(1) CHARACTER SET