Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: VARCHAR2(1) vs CHAR(1)
If I change VARCHAR2(1) into CHAR(1) column type in table, what could
happened? Will the application (expecting the VARCHAR2(1) column type)
work correctly anymore by automatically converting the value from
CHAR(1) into VARCHAR2(1) type?
-- Stjepan Brbot "Marco Muracchioli" <reply.on_at_group.please> wrote in message news:aqP09.129764$Jj7.2997288_at_news1.tin.it...Received on Sun Jul 28 2002 - 16:39:42 CDT
> Hi,
>
> you should use char type if you need to store 1 or 2 char in the
field.
> Consider that varchar types need, phisically, more information than a
simple
> char type (such as size).
> If you know that the field always contains null or 1 character (null
or 2
> characters for char(2)), char is the cheapest and fast solution.
> "Fast" include the more speed than the DBMS need to organize and
manage a char
> data, because it always know the exact size and never need to
calculate it.
>
> Marco
>
>