Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: CHAR vs VARCHAR
With CHAR(4) the data will be recorded using exactly 4 caracters.
With VARCHAR(4) the date will be recorded up to 4 caracters.
So if you are sure that the data to be stored is exactly 4 caracters long,
then use CHAR(4). The record will be optimized.
Jerome
"Paul Pruchnik" <paulrp_at_earthlink.net> a écrit dans le message de news:
5eria.3978$ey1.309583_at_newsread1.prod.itd.earthlink.net...
> Greetings,
> What is the savings of CHAR(4) vs VARCHAR(4) for storing a 4 (required)
> character code? What is the overhead in using VARCHAR for fields of
required
> length?
> Thanks,
> -Paul Pruchnik
>
>
Received on Wed Apr 02 2003 - 01:29:29 CST
![]() |
![]() |