Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

getting both Boolean true/false as 1 with ODBC load from mySql

I'm loading a table with Boolean fields from mysql using ODBC.

I get both true and false as value 1 in the QVD.

Can someone assist?

Thanks,

Boris

Tags (2)
1 Reply
Not applicable

Re: getting both Boolean true/false as 1 with ODBC load from mySql

Try with OLE DB .. even here you will get boolean as -1 , 0