Re: [HACKERS] LZTEXT for rule plan stings

> 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