Hmm, true. In fact, this reminds me that MySQL actually doesn't have a
BOOLEAN type. BOOLEAN is indeed just a synonym for TINYINT:
http://dev.mysql.com/doc/refman/5.7/en/numeric-type-overview.html
>From a defensive programming perspective, you might want to make that regex
(?i:TINYINT(\s*\(\d+\))?(\s*UNSIGNED)?)
Just to be sure ;-)
2014-06-25 12:04 GMT+02:00 Ben Hood <[email protected]>:
> On Wed, Jun 25, 2014 at 10:56 AM, Lukas Eder <[email protected]> wrote:
> > It should be bit, but to be sure, check what is reported by
> > INFORMATION_SCHEMA.COLUMNS.COLUMN_TYPE
>
> select column_type from information_schema.columns
> where table_name = 'members' and column_name = 'admin';
>
> column_type
> -----------
> tinyint(1)
>
> So armed with this knowledge, I am now able to use the following
> stanza in the generator config:
>
> <forcedType>
> <name>BOOLEAN</name>
> <types>(?i:TINYINT)</types>
> </forcedType>
>
> Thank you very much for your help :-)
>
> --
> You received this message because you are subscribed to the Google Groups
> "jOOQ User Group" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
