Hello Juan, You're right. MySQL doesn't really know a true boolean type: http://dev.mysql.com/doc/refman/5.5/en/numeric-type-overview.html
It uses "bool" / "boolean" for compatibility reasons with other databases, that support true booleans. See also this page: http://dev.mysql.com/doc/refman/5.5/en/other-vendor-data-types.html Currently, there is no custom type mapping in jOOQ, so your boolean column is mapped to Byte. This reminds me that I should actually implement a custom type mapping configuration in jooq-meta / jooq-codegen: https://sourceforge.net/apps/trac/jooq/ticket/947 Cheers Lukas 2011/11/15 Juan Miguel Cejuela <[email protected]>: > well, tinyint(1) gets converted to Byte too. After all bool, boolean are > synonyms to tinyint(1) in mysql > > > 2011/11/15 Juan Miguel Cejuela <[email protected]> >> >> Hi there, >> >> using MySQL 5.5.15 my columns with type BOOL or BOOLEAN get converted into >> Byte. >> >> Is this normal or is this a bug? Workaround now is tinyint(1) ? >> >> >> Thanks, //keep the amazing good work Lukas >> >> >> >> -- >> Juan Miguel Cejuela >> [email protected] >> jmcejuela.com >> +49 176 627 581 05 >> > > > > -- > Juan Miguel Cejuela > [email protected] > jmcejuela.com > +49 176 627 581 05 > >
