Re: Is the use of VARCHAR(256) as Primary Keys preferred in Oracle?

On 2002-11-18 22:57, Karsten Farrell <kfarrell_at_belgariad.com> wrote:
> When I started with my company, there was a widespread belief among the
> developers that Oracle stored any column smaller than VARCHAR2(2048) as
[...]
> We have so many 2048-byte columns in our database because of this
> belief ... but I've since shrunk most of them

Why did you shrink them? A varchar2(2048) doesn't take up more space that a varchar2(176). If I could, I would declare all character columns as varchar(infinity), and stop worrying how long the data can actually become.

        hp

-- 
   _  | Peter J. Holzer    | Schlagfertigkeit ist das, was einem
|_|_) | Sysadmin WSR       | auf dem Nachhauseweg einfällt.
| |   | hjp_at_hjp.at         |    -- Lars 'Cebewee' Noschinski in dasr.
__/   | http://www.hjp.at/ |