[SQLObject] BoolCol and the backend datatypes

[Markus G. <m.g...@gm...>]

Hi,

in SQLObject a BoolCol() is stored as TINYINT(4) in the MySQL backend
and as TINYINT in the SQLite backend.  Both are not optimal IMO:

*) MySQL knows BOOL (and since version 4.1 also BOOLEAN), which is a
synonym for TINYINT(1).
(http://dev.mysql.com/doc/refman/4.1/en/numeric-type-overview.html)

*) TINYINT is not part of ANSI SQL and should IMO therefore not be
used in the SQLite backend.  SQLAlchemy uses BOOLEAN.

Kind regards,
Markus