Search Postgresql Archives

Re: Single character bitfields

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



-----Original Message-----
From: Tomasz Ostrowski [mailto:tometzky@xxxxxxxxxxxxx] 
Sent: Thursday, 21 August 2008 18:46
To: a.maclean@xxxxxxxxxx
Cc: General
Subject: Re: Single character bitfields

On 2008-08-21 05:29, Andrew Maclean wrote:

> Is char(1) one byte in size?

No. It will also depend on database encoding, etc.

I think you should go with smallint, which is exactly 2 bytes. You'll
have 15 bits of storage (16 if you'd want to implement the special case
of minus sign).

IMHO the only smaller field are:
- one byte boolean, but it can only store 1 bit.
- one byte "char" (with quotes), but it is a non standard, integral
type, will cause interface problems and I don't know if it will not be
deprecated some time.

Regards
Tometzky
-- 
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
                                                      Winnie the Pooh


Thankyou for this, after reading around I have also come to the same
conclusion that smallint is the better option.

Andrew




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux