pyodbc giving None when the data in a row has string length more that 216 characters

[GoogleCodeExporter]

What steps will reproduce the problem?
1. using pyodbc fetch a value from a table whose length is more than 216 
character
2.
3.

What is the expected output? What do you see instead?

It should retrieve the values instead is giving value None

What version of the product are you using? On what operating system?
Active State python 2.6
pyodbc 2.1.6

Please provide any additional information below.

Original issue reported on code.google.com by siddhartha.veedaluru@gmail.com on 13 Oct 2010 at 12:54

[GoogleCodeExporter]

I need some more information, particularly which database.  Could you also post 
the code?

There are a number of unittests in the /tests directory you may want to try.  
In particular, the SQL Server test set includes reading strings of these sizes: 
0, 1, 255, 256, 510, 511, 512, 1023, 1024, 2047, 2048, 4000, 4095, 4096, 4097, 
10240, 20480

I'm pretty sure it isn't just a generic size issue.

You mention "table" whose length.  Do you have a row with a lot of fields that 
add up to more than 216 characters or is it a single value?

Original comment by mkleehammer on 20 Nov 2010 at 7:21

• Changed state: Investigating

[GoogleCodeExporter]

Original comment by mkleehammer on 21 Nov 2010 at 5:18

• Added labels: Python2

[GoogleCodeExporter]

Original comment by mkleehammer on 21 Nov 2010 at 5:20

• Changed state: Hold

[GoogleCodeExporter]

Closing due to inactivity.

Original comment by mkleehammer on 29 Sep 2012 at 7:48

• Changed state: WontFix