Hey, Can Heidi display boolean values as 0/1, rather than 'TRUE'/'FALSE'. I export a table with boolean values in from Heidi, but all boolean fields are string 'TRUE'/'FALSE' which I can't then re-import into MS SSMS.
Display BOOLEAN as 0/1, not 'TRUE'/'FALSE'
If you're doing it as a SELECT, you can acheive it by using an IF statement.
Here's a basic example:
SELECT IF (ID_Client >= 1000, '1', '0') FROM Clients [...]
Where the second argument determines what happens if the condition is true and the thrid if it's false. That would get you a list of ones and zeros instead of TRUE and FALSE.
I hope that can help.
Please login to leave a reply, or register at first.