[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/