Issue 96: integer and real problem in pyodbc
Status:  Hold
Owner: ----
Reported by danh...@gmail.com, Apr 6, 2010
I am new in pyodbc programming and i try to get some integer values from 
from a MDB
file and the script return a number like this for the integer: 3750193.
Please help
to find out where is my mistake.
Thank you


ivoirdata2.py
656 bytes   View   Download
Nov 21, 2010
Project Member #1 mkleehammer
I'm not really sure what the issue is -- 3750193 actually is an integer.  I suppose it is the wrong value?  If so, what is the value you expected?

Can you supply an example MDB with a couple of rows to test with?

Status: Hold
Feb 10, 2011
#2 terrasea
I get similar results from a table with Long Integer values of 290 being returned by pyodbc as 3160370 and Double values of 40 being returned as 6.9524415266644334e-310.

I'm running Ubuntu Linux 64 bit
Linux version 2.6.32-28-generic (buildd@allspice) (gcc version 4.4.3 (Ubuntu 4.4.3-4ubuntu5) ) #55-Ubuntu SMP Mon Jan 10 23:42:43 UTC 2011
Python 2.6.5 (r265:79063, Apr 16 2010, 13:57:41)
[GCC 4.4.3] on linux2
pyodbc-2.1.8