Row Buffer Width exceeded

[slai]

Hy it may sound strange but i need to open that table (nobody designs a table like that :-)):

CREATE TABLE TEMPDRUCKTABLE1 (
SFELD1 VARCHAR(500) CHARACTER SET UTF8 COLLATE UTF8,
SFELD2 VARCHAR(500) CHARACTER SET UTF8 COLLATE UTF8,
SFELD3 VARCHAR(500) CHARACTER SET UTF8 COLLATE UTF8,
SFELD4 VARCHAR(500) CHARACTER SET UTF8 COLLATE UTF8,
SFELD5 VARCHAR(500) CHARACTER SET UTF8 COLLATE UTF8,
SFELD6 VARCHAR(500) CHARACTER SET UTF8 COLLATE UTF8,
SFELD7 VARCHAR(500) CHARACTER SET UTF8 COLLATE UTF8,
SFELD8 VARCHAR(500) CHARACTER SET UTF8 COLLATE UTF8,
SFELD9 VARCHAR(500) CHARACTER SET UTF8 COLLATE UTF8,
SFELD10 VARCHAR(500) CHARACTER SET UTF8 COLLATE UTF8,
SFELD11 VARCHAR(500) CHARACTER SET UTF8 COLLATE UTF8,
SFELD12 VARCHAR(500) CHARACTER SET UTF8 COLLATE UTF8,
SFELD13 VARCHAR(500) CHARACTER SET UTF8 COLLATE UTF8,
SFELD14 VARCHAR(500) CHARACTER SET UTF8 COLLATE UTF8,
SFELD15 VARCHAR(500) CHARACTER SET UTF8 COLLATE UTF8,
SFELD16 VARCHAR(500) CHARACTER SET UTF8 COLLATE UTF8,
SFELD17 VARCHAR(500) CHARACTER SET UTF8 COLLATE UTF8,
SFELD18 VARCHAR(500) CHARACTER SET UTF8 COLLATE UTF8,
SFELD19 VARCHAR(500) CHARACTER SET UTF8 COLLATE UTF8,
SFELD20 VARCHAR(500) CHARACTER SET UTF8 COLLATE UTF8,
MFELD1 BLOB SEGMENT SIZE 1,
MFELD2 BLOB SEGMENT SIZE 1,
MFELD3 BLOB SEGMENT SIZE 1);


it worked with zeos 6.6.6 and firebird 2.1 but not with 2.5.
The Error Message is, Row Buffer Width exceeded

greetings

[EgonHugeist]

Which version of Zeos do you use?

I'd run that query and it works...

[slai]

Hy Yea running the query and creating the table is no problem.
But open it with a TZTable, is not possible. Can you please try that?

thx!

[seawolf]

The problem is on FB 2.5 a varchar(500) require 2000 bytes.
So 2000 x 20 (varchar fields) = 40k which exceed the limit (32767)

[slai]

thx a lot! i will try it tonight!