Le JeanMimi wrote:
> Hello,
>
> A developer told us that it was best to avoid declaring VARCHAR2
> columns of more than 255 bytes when possible.
> He pretends that Oracle will reserve huge blocks for the resultset
> when the varchar2 size is over 255.
>
> I've never heard of that before. (and don't really believe it)
> May be in a previous version ?
>
> Can you help me ?
You have been given a bunch of good advices. Use as big VARCHAR2s as
needed. The only concern could be if you want to use VARCHAR2s bigger
than 2000 bytes. I have encountered in the past several bugs related to
processing of them especially on lower Oracle versions (8i) in
combination with some both Oracle and external tools. So test carefully
before going live with long VARCHAR2s.
--
Dusan Bolek
Received on Tue Apr 12 2005 - 02:28:50 CDT
