> I see tables that have two or three varchar(4000) columns with other
> data, i.e. names and stuff that are also varchar but smaller. I know
> that these don't actually get stuffed with 4000 chars but rather
> that 4KB is the upper limit of the size of an Oracle varchar and that
> the author's been lazy. If I had a compressed text or varchar type
> I'd be quite confident that the application code would run even with
> an 8KB block size.
Just to clearify, varchar(4000) does not take 4000 chars on disk, while
char(4000) does use 4000 chars on the disk.
-- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026