[pywin32-bugs] [ pywin32-Bugs-1258840 ] odbc - select 'bit' type returns str, not int

[SourceForge.net <no...@so...>]

Bugs item #1258840, was opened at 2005-08-14 17:18
Message generated for change (Comment added) made by mhammond
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=551954&aid=1258840&group_id=78018

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: win32
Group: None
>Status: Closed
>Resolution: Fixed
Priority: 5
Submitted By: Frank Millman (frankmillman)
Assigned to: Nobody/Anonymous (nobody)
Summary: odbc - select 'bit' type returns str, not int

Initial Comment:
I use odbc to connect to MS SQL Server.

I have just started using the 'bit' datatype, which stores 
an integer value of 1 or 0.

If I execute a SELECT which inludes a 'bit' column, the 
value is returned correctly, but it is returned as a str ('1' 
or '0') instead of an int.

It is easy to convert the result to an int, but it would be 
nice if odbc returned an int in the first place.

Thanks

Frank Millman


----------------------------------------------------------------------

>Comment By: Mark Hammond (mhammond)
Date: 2006-02-27 23:01

Message:
Logged In: YES 
user_id=14198

Checking in src/odbc.cpp;
new revision: 1.15; previous revision: 1.14
Checking in test/test_odbc.py;
new revision: 1.2; previous revision: 1.1

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=551954&aid=1258840&group_id=78018