[Info-ingres] Re: max varchar width

#1

You cannot do this on 2.5 (at least that I can see). You can do it on R3.
I don't know about 2.6. You could check the manual if you need to check
this.
----- Original Message -----
From: <info-ingres-request (AT) cariboulake (DOT) com>
To: <info-ingres (AT) cariboulake (DOT) com>
Sent: Saturday, March 19, 2005 4:21 AM
Subject: Info-ingres digest, Vol 1 #128 - 10 msgs

Quote:

Message: 1
From: martin.bowes (AT) ctsu (DOT) ox.ac.uk
To: info-ingres (AT) cariboulake (DOT) com
Date: Fri, 18 Mar 2005 13:44:49 -0000
Subject: [Info-ingres] max varchar width

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

[Info-ingres] Re: max varchar width

comp.databases.ingres comp.databases.ingres

[Info-ingres] Re: max varchar width - 03-20-2005 , 07:29 PM