Re: Oracle database configuration options
From: suvas <suvas_at_pacific.net.sg>
Date: 1996/11/18
Message-ID: <01bbd5d6$394bb0c0$465078cb_at_Singnet.singnet.com.sg>#1/1
Date: 1996/11/18
Message-ID: <01bbd5d6$394bb0c0$465078cb_at_Singnet.singnet.com.sg>#1/1
Consider these situations
1)If field1(n) and all rows will invariably be always of n length
2)If field1(1) is unit length
Both these cases I suppose char will be a better choice since it need not
keep track the length of
data
Paul Brewer <paulb_at_pbrewer.demon.co.uk> wrote in article
<Sb4f0HA$gndyEwqq_at_pbrewer.demon.co.uk>...
> Thanks to Jim and Thomas for the advice (VARCHAR2 vs. CHAR?).
>
> Seems then, no reason not just to use VARCHAR2 for everything
> alphanumeric and forget about CHAR.
>
> Or am I missing something?
>
> Paul Brewer
>
Received on Mon Nov 18 1996 - 00:00:00 CET