search

djhenderson / pyodbc

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

MSAcces and pyodbc #119

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Thaks in advance for your coments. I'm just beginig to work with pyodbc
but I get some extrange results:

What steps will reproduce the problem?
1. Try to order or compare integer values in a query to msaccess. 
2. The same query works in access (I copy & paste from from de SQL view window)
3.

What is the expected output? What do you see instead?
666 < 1000 
I get a digit by digit comparision, not an integer one...

What version of the product are you using? On what operating system?

WindowsXP, python26 and pyodbc 2.1.8

Please provide any additional information below.

Original issue reported on code.google.com by haizea2...@gmail.com on 10 Sep 2010 at 12:04

GoogleCodeExporter commented 9 years ago 
Can you provide an example table and query?

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