CellProfiler/CellProfiler — Issue #283: ExportToDatabase: Handling of booleans in SQLite
Author: braymp
Created: 2012-02-04 05:55:59+00:00
State: open

SQLite stores booleans as integers: http://www.sqlite.org/datatype3.html#boolean. This causes an error if per-object output from ClassifyObjects is written to the db. It would need to be stored as a 1/0 (http://stackoverflow.com/questions/843780/store-boolean-value-in-sqlite) or as a literal 'true'/'false' value (http://forums.realsoftware.com/viewtopic.php?f=3&t=3974).

Looking again, seems like it would have to an integer based on get_measurement_columns in ClassifyObjects.

From this forum post: http://cellprofiler.org/forum/viewtopic.php?f=14&t=1605&p=6432#p6432