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 ?
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
