How to export TINYINT(1) as TRUE/FALSE
Posted: 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?