booleans dont work in MS-SQL

[Mike Bayer]

if you have BOOLEAN and set a bind parameter to True/False using pymssql, you get an internal error.

[Former user]

two methods to add to SLBoolean (and possibly MSBoolean) class to fix broken boolean handling code.

[Former user]

this problem exists in sqlite.py as well. both sqlite and mssql store True/False as 1/0. i fixed this by adding two methods to the SLBoolean (or MSBoolean) classes (attached).

i don't know SQLAlchemy well enough to determine if this is an acceptable fix or not, but it works for me for now. there should probably be a common class for booleans that are represented as integers, which is subclassed for the different databases.

[Mike Bayer]

yes it looks reasonable, ill take a look at this soon. thanks !

[Mike Bayer]

this was fixed for mysql/sqlite/ms-sql (tested for the first two only tho) in changeset:1704.

[Mike Bayer]

Removing milestone: 0.3.0 (automated comment)