Error-3933 : The maximumn Possible length in the Table is Too long.

Database
Enthusiast

Error-3933 : The maximumn Possible length in the Table is Too long.

Hi all ,

when i try to create a table with the below specified structure , TD gives an error

Error-3933 : The maximumn Possible length in the Table is Too long.
I have an Idea that TD MAX ROW LENGTH is 64k and one of the columns with data type long varchar itself occupies 64000 bytes.
Can i increase the Row Max Length value to say 128 k ? and also please tell me how Varchar stores the Data internally , I mean if i Specify varchar(1) , how much amount of space it occupies actually. Is it 1 *16 bytes ?

CREATE MULTISET TABLE stgdb_dv8.test_table1 ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
name VARCHAR(5000 ) CHARACTER SET LATIN NOT CASESPECIFIC,
name1 VARCHAR(5000 ) CHARACTER SET LATIN NOT CASESPECIFIC,
name2 VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,
name3 long varchar
)
PRIMARY INDEX NUPI_TEST ( name );

1 REPLY
Enthusiast

Re: Error-3933 : The maximumn Possible length in the Table is Too long.

Hi All ,

Any one there to help me in this regard