Hi Dudes,

Given that I have 4k cache configured. and that the
max_tuple_length is set to zero. Why can't I set the width of a not null
not default varchar field to the max allowable rowsize for a page - less
2bytes for the varchar length indicator?

At the moment I cant make a varchar > 2000.
I can make a table with:
field1 varchar(2000),
field2 varchar(1982)

I would have expected that max varchar on a 4k page was
3988-2(for the length indicator)-1(for null indicator).= 3985. Hell, I'd be
happy with varchar (3900).

But I get errors like:

E_US07DE CREATE or ALTER TABLE: invalid column format 'varchar'
on column

Apart from the sheep, what am I missing?

Martin Bowes.
--
Random Duckman Quote #72:
Other: Make a move & you're dead meat.
Duckman: Does wetting myself count as moving?

Hi Karl et al,

Spot on. Running on a 2.5 and a 2.0 installation. Reading a 2.6
manual.

Bugger!

Marty

--
Random Farscape Quote #24:
Sikozu - Aah Sarcasm, the hallmark of the sub-educated.
Chiana - The only hallmark you'll be is a tiny, tiny smudge on the wall
after I
shoot you.