Re: oracle disk space
Date: 4 Mar 92 20:45:57 GMT
Message-ID: <1992Mar4.204557.8668_at_qiclab.scn.rain.com>
In article <19924.972.6724_at_dosgate> "howard kaplan" <howard.kaplan_at_canrem.com> writes:
>I have heard an unconfirmed *rumour* about disk space usage in
>future versions of Oracle. According to this rumour,
>1) Character fields will have all of their trailing blanks stored on
> the database, requiring much more disk space than at present.
In v6, the datatype CHAR stores no trailing blanks (no 'padding').
In v7, by default, calling something CHAR works the same as in v6. However, if you specify non-v6-compatible-mode, you will see the following two datatypes:
CHAR pads with trailing blanks to fill space VARCHAR2 behaves like v6 CHAR VARCHAR is a reserved word; the ANSI committee is still trying to define how *they* think VARCHAR should behave.
Your v6 CHAR fields automatically become v7 VARCHAR2 fields, but you may still refer to this non-padding datatype with the word 'CHAR' as long as you're in v6 compatibility mode.
>2) This change is required for conformity to an SQL standard.
>Can anyone clarify the truth behind this rumour?
> Howard Kaplan, Toronto
> howard.kaplan_at_canrem.com
>Canada Remote Systems - Toronto, Ontario/Detroit, MI
>World's Largest PCBOARD System - 416-629-7000/629-7044
Hope this helps.
Cheers.
-- Thomas Cox I work for Oracle, but I speak only for myself. tcox_at_us.oracle.com work: 503-220-1678Received on Wed Mar 04 1992 - 21:45:57 CET