[DB-SIG] None and BOOLEAN columns
Dittmar, Daniel
daniel.dittmar@sap.com
Wed, 6 Mar 2002 12:28:20 +0100
What is the expected behaviour with regard to NULL, TRUE, FALSE and BOOLEAN
columns?
In the SAP DB driver, I translate None (or any other value interpreted as
false) to a SQL False value, so there is currently no possibility to insert
a real NULL value.
On SELECT, I translate both NULL and FALSE to None.
Admittedly, this comes from my own Python + SQL style, where I use None as
false on the Python side and try to stay away from three valued logic on the
SQL side.
What do other drivers do?
Daniel
--
Daniel Dittmar
SAP DB, SAP Labs Berlin
daniel.dittmar@sap.com
http://www.sapdb.org/