mySQL boolean columns in table creation ?

One Star

mySQL boolean columns in table creation ?

Hi
I'm using Talend v3.1 RC3 and Java jobs, and I'm trying to create mySQL tables with some boolean columns, but cannot find the BOOLEAN db type.
when a column in the schema is Boolean or boolean, the mapping to DB types is BIT(1) instead of BOOLEAN.
I thought it was nearly the same, but inserting true/false values in these BIT columns, the value I get in the table is "b".
Did I miss something ?
Community Manager

Re: mySQL boolean columns in table creation ?

Hello
Mysql use TINYINT(1) to replace BOOLEAN, so you should select Boolean on Type column and TINYINT on DB types column.
true will be 1 and false will be 0.
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business