Re: VARCHAR length

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 8 Oct 2002 23:22:32 +1000
Message-ID: <XOAo9.48663$g9.140182@newsfeeds.bigpond.com>

Hi Eino,

DON'T use VARCHAR, use VARCHAR2 (until Oracle officially decides what it wants to do with VARCHAR).

Assuming VARCHAR2, the difference between the 3 is simply the maximum allowable characters permissible. All three are variable in length and will only store the characters as specified (unlike it's cousin CHAR which pads out with spaces up to the defined length).

There is zippo effect on performance between the three. Business rules and an appropriate maximum allowable length should govern which one to use.

Cheers

Richard
"Eino Komsi" <komsiikomsaa_at_yahoo.com> wrote in message news:10b3c267.0210080443.f2c562_at_posting.google.com...
> hi,
>
> Is there a difference between VARCHAR(100), VARCHAR(300) or
> VARCHAR(2000).
>
> I mean, is there really a difference if I have 140Gt of hard disk
> space, and I specify a field to be 300 instead of possible 2000.
> Performance?
>
> regards,
> Eino Komsi
Received on Tue Oct 08 2002 - 08:22:32 CDT