Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle database configuration options
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 CST