topic getting both Boolean true/false as 1 with ODBC load from mySql in QlikView https://community.qlik.com/t5/QlikView/getting-both-Boolean-true-false-as-1-with-ODBC-load-from-mySql/m-p/875475#M659481 <HTML><HEAD></HEAD><BODY><P>I'm loading a table with Boolean fields from mysql using ODBC.</P><P>I get both true and false as value 1 in the QVD.</P><P></P><P>Can someone assist?</P><P></P><P></P><P>Thanks,</P><P></P><P>Boris</P></BODY></HTML> Tue, 21 Apr 2015 12:29:07 GMT 2015-04-21T12:29:07Z getting both Boolean true/false as 1 with ODBC load from mySql https://community.qlik.com/t5/QlikView/getting-both-Boolean-true-false-as-1-with-ODBC-load-from-mySql/m-p/875475#M659481 <HTML><HEAD></HEAD><BODY><P>I'm loading a table with Boolean fields from mysql using ODBC.</P><P>I get both true and false as value 1 in the QVD.</P><P></P><P>Can someone assist?</P><P></P><P></P><P>Thanks,</P><P></P><P>Boris</P></BODY></HTML> Tue, 21 Apr 2015 12:29:07 GMT https://community.qlik.com/t5/QlikView/getting-both-Boolean-true-false-as-1-with-ODBC-load-from-mySql/m-p/875475#M659481 2015-04-21T12:29:07Z Re: getting both Boolean true/false as 1 with ODBC load from mySql https://community.qlik.com/t5/QlikView/getting-both-Boolean-true-false-as-1-with-ODBC-load-from-mySql/m-p/875476#M659482 <HTML><HEAD></HEAD><BODY><P>Try with OLE DB .. even here you will get boolean as -1 , 0</P></BODY></HTML> Thu, 03 Mar 2016 06:00:10 GMT https://community.qlik.com/t5/QlikView/getting-both-Boolean-true-false-as-1-with-ODBC-load-from-mySql/m-p/875476#M659482 2016-03-03T06:00:10Z