Re: Database compression..?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 7 Apr 1999 18:04:17 +0100
Message-ID: <923504918.19878.0.nnrp-03.9e984b29@news.demon.co.uk>

The last time I checked it (7.3.3.5 I think), a null CHAR was stored as a null, not as a string of chr(32). So the total cost of storing a non-trailing null CHAR as just the one-byte 'length byte'.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Chris Hamilton wrote in message <370c4803.1624235_at_news.erols.com>...
>Oracle will store only a "null" indicator (one byte) in the column if
>it is defined as VARCHAR2 or NUMBER datatype. If it is a fixed-length
>CHAR column, it will store the actual blank spaces.
Received on Wed Apr 07 1999 - 12:04:17 CDT