https://community.qlik.com/t5/Talend-Studio/mySQL-boolean-columns-in-table-creation/m-p/2295603#M68353 Hi<BR />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.<BR />when a column in the schema is Boolean or boolean, the mapping to DB types is BIT(1) instead of BOOLEAN.<BR />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".<BR />Did I miss something ? Sat, 16 Nov 2024 13:57:57 GMT Anonymous 2024-11-16T13:57:57Z https://community.qlik.com/t5/Talend-Studio/mySQL-boolean-columns-in-table-creation/m-p/2295603#M68353 Hi<BR />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.<BR />when a column in the schema is Boolean or boolean, the mapping to DB types is BIT(1) instead of BOOLEAN.<BR />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".<BR />Did I miss something ? Sat, 16 Nov 2024 13:57:57 GMT https://community.qlik.com/t5/Talend-Studio/mySQL-boolean-columns-in-table-creation/m-p/2295603#M68353 Anonymous 2024-11-16T13:57:57Z https://community.qlik.com/t5/Talend-Studio/mySQL-boolean-columns-in-table-creation/m-p/2295604#M68354 Hello <BR />Mysql use TINYINT(1) to replace BOOLEAN, so you should select Boolean on Type column and TINYINT on DB types column. <BR />true will be 1 and false will be 0. <BR />Best regards <BR /> <BR /> shong Mon, 11 May 2009 04:04:34 GMT https://community.qlik.com/t5/Talend-Studio/mySQL-boolean-columns-in-table-creation/m-p/2295604#M68354 Anonymous 2009-05-11T04:04:34Z