MySQL Forums
Forum List  »  Analytics, Reporting, BI

Get bit(1) fields as tinyint to Qlikview BI system with ODBC
Posted by: Boris Kacevich
Date: April 21, 2015 08:20AM

Hello,

I'm trying to load a table form mySql to QlikView reporting tool.
I have a field which is bit(1) to represent a boolean value.
when I load this field I get both for true/false the number 1.

I want, on the load script to convert the data type from bit(1) to tinyint, how can I do it?

Thanks,

Boris

Options: ReplyQuote


Subject
Written By
Posted
Get bit(1) fields as tinyint to Qlikview BI system with ODBC
April 21, 2015 08:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.