Skip to Content.
Sympa Menu

freetds - [freetds] How to increase DBTEXTSIZE and DBTEXTSIZE.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Velichko Yuriy <velichko.yuriy AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] How to increase DBTEXTSIZE and DBTEXTSIZE.
  • Date: Wed, 15 Jan 2014 11:26:03 +0200

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!




Archive powered by MHonArc 2.6.24.

Top of Page