search

jiaoz / pyodbc

Automatically exported from code.google.com/p/pyodbc
MIT No Attribution
0 stars 0 forks source link

integer and real problem in pyodbc #96

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
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

Original issue reported on code.google.com by danh...@gmail.com on 7 Apr 2010 at 6:53

Attachments:

GoogleCodeExporter commented 8 years ago 
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?

Original comment by mkleehammer on 21 Nov 2010 at 6:26

GoogleCodeExporter commented 8 years ago 
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

Original comment by terrasea on 11 Feb 2011 at 4:01