My favorites | Sign in
Project Home Downloads Wiki
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 315: Pyodbc is corrupting fetched fields
2 people starred this issue and may be notified of changes. Back to list
Status:  New
Owner:  ----


 
Reported by archank2...@gmail.com, Mar 29, 2013
What steps will reproduce the problem?
1. Connect to database
2. Select * from a table containing varchars
3. print contents

What is the expected output? What do you see instead?
Expected outout should be :
[(1,'Display')]
Instead I see:
[(1,'\x00\x00\x00\x00lay')]

What version of the product are you using? On what operating system?
Linux <name> 2.6.18-348.3.1.el5 #1 SMP Tue Mar 5 13:19:32 EST 2013 x86_64 x86_64 x86_64 GNU/Linux

pyodbc-2.1.5-2.el5

Please provide any additional information below.

Apr 23, 2013
#1 pahughe...@gmail.com
Same problem here.  Product version/OS:

Linux <name> 3.0.58-0.6.6-default #1 SMP Tue Feb 19 11:07:00 UTC 2013 (1576ecd) x86_64 x86_64 x86_64 GNU/Linux

>>> pyodbc.version
'3.0.6'

Oct 21, 2013
#2 a.p.chat...@gmail.com
Has anyone found the reason why this is happening ?

RHEL 5
MSSQL 2008
pyodbc 3.0.7
sqlalchemy
freetds 0.91
unixodbc 2.3.0

had to use pypyodbc 
Oct 22, 2013
#3 archank2...@gmail.com
In my case, the driver was 32 bit and pyodbc was 64 bit 
Oct 14, 2014
#4 RyanCaco...@gmail.com
This may be related to this issue: https://code.google.com/p/pyodbc/issues/detail?id=78&can=1 due to a patch being reverted at some point

Powered by Google Project Hosting