[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

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 Dittmar
SAP DB, SAP Labs Berlin