Issue 127: pyodbc giving None when the data in a row has string length more that 216 characters
Status:  WontFix
Owner: ----
Closed:  Sep 2012
Reported by siddhartha.veedaluru@gmail.com, Oct 13, 2010
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.


Nov 20, 2010
Project Member #1 mkleehammer
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?
Status: Investigating
Nov 21, 2010
Project Member #2 mkleehammer
(No comment was entered for this change.)
Labels: Python2
Nov 21, 2010
Project Member #3 mkleehammer
(No comment was entered for this change.)
Status: Hold
Sep 29, 2012
Project Member #4 mkleehammer
Closing due to inactivity.
Status: WontFix