Pyodbc Doesn't extract full blob about pyodbc

[GoogleCodeExporter]

It works on Windows with the Microsoft ODBC driver and is part of the SQL 
Server unit tests.  On Linux you would be using FreeTDS I assume.  I believe 
that's where our difference lies.

Can you generate an ODBC trace on Linux?

Original comment by mkleehammer on 29 Jul 2011 at 1:12

• Changed state: Investigating

[GoogleCodeExporter]

I'm getting the same 4096 limit for text fields via FreeTDS on ubuntu 10.04. I 
get the full result in tsql, but it is truncated in pyodbc. I have attacted an 
ODBC trace.

Original comment by [email protected] on 3 Aug 2011 at 7:04

Attachments:

• sql.log

[GoogleCodeExporter]

I found a way to fix it with free tds in your select statement you
must add the following to it:

SET TEXTSIZE 2147483647

so for instance it would look like: cursor.execute("SET TEXTSIZE
2147483647 select * from blah")

Original comment by [email protected] on 4 Aug 2011 at 11:47

[GoogleCodeExporter]

I found a way to fix it with free tds in your select statement you
must add the following to it:

SET TEXTSIZE 2147483647

so for instance it would look like: cursor.execute("SET TEXTSIZE
2147483647 select * from blah")

Original comment by [email protected] on 4 Aug 2011 at 11:47

[GoogleCodeExporter]

the FREETDS configuration has a set maximum on the returned size of a blob you 
can change this in the conf file but it's easier to do what's stated above

Original comment by [email protected] on 4 Aug 2011 at 11:48

[GoogleCodeExporter]

Looks like that worked. Thanks. I also found this stackoverflow explanation:

http://stackoverflow.com/questions/1060035/using-pyodbc-on-ubuntu-to-insert-a-im
age-field-on-sql-server/1073801#1073801

Original comment by [email protected] on 4 Aug 2011 at 1:49

[GoogleCodeExporter]

It looks like I am also able to fix it by switching TDSVER to 8.0 like so:

os.environ['TDSVER'] = '8.0'

Original comment by [email protected] on 4 Aug 2011 at 2:52

[GoogleCodeExporter]

Original comment by mkleehammer on 23 Dec 2011 at 8:13

• Changed state: NoFix