Maximmum table/view size

juki · #1 (**permalink**) 11-28-05, 04:34

Hi,

To simplify my problem:
I want to create a table like this

create table a (fld1 lvarchar(20000), fld2 lvarchar(20000));

Maximum size seems to be 32767.
Is there a way to increase this?

gurey · #2 (**permalink**) 11-28-05, 09:04

Hi,

Please use char instead of lvarchar.

Gustavo.

juki · #3 (**permalink**) 11-28-05, 09:22

Same problem.
Maximum seems to be 32767 for the whole table

blackguard · #4 (**permalink**) 11-28-05, 09:23

Quote:

Originally Posted by juki

Same problem.
Maximum seems to be 32767 for the whole table

Use text data type instead.

Internet Services

Web Development

Digital Marketing

Consumer Tech