Page 1 of 1

TuniTable postgresql varchar limit ?

Posted: Tue 07 Apr 2009 16:19
by adroege
If I create a table like this in Postgresql

CREATE TABLE test(
f1 integer,
c2 character varying(4194304)
);

And then I use the Demo program of the TuniTable provided by Devart to access this table, I get very strange behavior trying to update or insert into the c2 column.

Is there a limit with the TUniDac components regarding the largest varchar they will access in Postgresql? If so what is the limit?

Thanks!

Posted: Wed 08 Apr 2009 08:00
by Plash
The limit for a string field length is 65535. In the next build we'll add a fix. So fields with length more than 8191 will be mapped to TMemoField.

In the current build you can set the LongStrings option of TUniQuery to False for mapping such fields to TMemoField.