Re: Why is VARCHAR2(4000) bad ?
From: Andrew M <andrew.markiewicz_at_gmail.com>
Date: Tue, 5 Feb 2008 05:52:50 -0800 (PST)
Message-ID: <fbb959cc-22ef-4667-ab86-7fe872b98d68@v17g2000hsa.googlegroups.com>
Date: Tue, 5 Feb 2008 05:52:50 -0800 (PST)
Message-ID: <fbb959cc-22ef-4667-ab86-7fe872b98d68@v17g2000hsa.googlegroups.com>
On Feb 4, 6:07 pm, DA Morgan <damor..._at_psoug.org> wrote:
> Read what JMoo wrote: Yes it does!
>
JMoo is talking about problems with other products like Toad or
languages such as Pro*C. If those are considerations then, yes, you
should design for it. I never said to arbitrarily use 4000 as the
length.
What I said was the presentation by Julian you cited talks about bind
variable mismatch which does not support the argument that it is bad
to use a varchar2 because it will use more memory, which is what you
were trying to suggest. It is misinforming.
Andrew Received on Tue Feb 05 2008 - 07:52:50 CST