Re: Oracle 8i - the space wasting pig

Andreas Jung wrote:
>
> Dear all,
>
> I am running a Oracle 8i database with UTF8 character set. I store text files
> inside a CLOB (extra lob segment). I can see that Oracle always needs two times
> the space to store the text inside the LOB segement compared to the size of the
> originial file. Is this a general problem or is this problem related to the
> UTF8 character set ?! It seems to me that Oracle need 2 bytes for every
> character although most of the text is pure Ascii.

UTF8 is a 16-bit character set. ASCII is an 8-bit character set, which lacks the NLS capabilities of UTF8. So storing in UTF8 will be twice as large as storing in ASCII - and if you used plain characters, the additional capability of UTF8 is wasted.

Cheers,

g

-- 
guy ruth hammond <grh_at_agency.com> | One is punished for being
Technology Analysis & Consulting  | weak, not for being cruel.
07879607148 http://www.agency.com |       -- Baudelaire