Start a new topic

Data export issue

[This topic is migrated from our old forums. The original author name has been removed]

Hello I am using db visualizer 9.1.10 I've got a MySQL table that has a column, "active" with data type Bit. The data that contains in that column are "0" or "1". If I use MySQL workbench query, I see the data in that column as "0" or "1". However if I query that same table in dB visualizer, it displays "true" or "false" instead. This is causing problem because I am trying to import the data to MS SQL Server table and during import, I get error that "true" or false" column does not exist. Why is dbvisualizer changing the the data format? Is there a way to fix this? Thanks Shane
1 Comment

[This reply is migrated from our old forums.]

Re: Data export issue
Shane, You can modify the appearance of boolean fields in Tools->Tool Properties and in the Data Formats setting. These settings are also available in the Export feature if you are looking to temporarily override any settings. Choose 1/0 if you want to output 1 and 0 instead of true and false. Regards Roger