[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 07:18
Message generated for change (Tracker Item Submitted) made by Item Submitter
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: Open
Resolution: None
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


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

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