How to increase DBTEXTSIZE and DBTEXTSIZE.

Velichko Yuriy <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CAN=WvWuEx+xxdT25DNo87TBjf+dxaZWFmzX5DS4++E7eRRKvKQ@mail.gmail.com>
Hello!

I need to fetch data from TEXT field.
But the data size of particular record is always 4096 (for data that
greater than 4kb)

int dataLength  = dbdatlen( conn, i + 1 );

I found (for db-lib) that need to increase options DBTEXTSIZE and
DBTEXTSIZE to solve this problem:
 
dbsetopt( conn, DBTEXTSIZE,  "2,147,483,647", -1 );

dbsetopt( conn, DBTEXTLIMIT, "2,147,483,647", -1 );

But these function return FAIL, and have no affect. The returned length
still 4096.

Is any other way in to fetch big data (text, varchar, varbinary...)?

-- 
Best Regards!
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.