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 ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
