How to export TINYINT(1) as TRUE/FALSE

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
DannyD
Posts: 6
Joined: Thu 10 Jun 2021 16:36

How to export TINYINT(1) as TRUE/FALSE

Post by DannyD » Thu 10 Jun 2021 21:02

I have fields in my database which are TINYINT(1). All values in these fields are 1 or 0. When I export the data, I would like to change the 1 values to TRUE and the 0 values to FALSE. In the Data Export dialog box, under Data formats, there is a section labeled 'Boolean', which has a default setting of 'true;false'. I tried changing that setting, but it didn't convert my TINYINT(1) values to TRUE/FALSE values. Is there a way to do this?

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: How to export TINYINT(1) as TRUE/FALSE

Post by dzhanhira » Mon 14 Jun 2021 06:38

please, clarify, where are you trying to export?

DannyD
Posts: 6
Joined: Thu 10 Jun 2021 16:36

Re: How to export TINYINT(1) as TRUE/FALSE

Post by DannyD » Wed 16 Jun 2021 19:01

I am exporting to Google Sheets

Post Reply