I am attempting to use a TCHeckBox with a MySQL 4.0.20 database at my ISP. I am using TINYINT for all of my boolean fields, because there is no true boolean column type. With this, all of my TCheckBox components are in the indeterminate state. I have tries changing the values to -1 and 1, but neither results in them being checked.
What is the correct column type for booleans from your perspective, and when what is the correct value for true.
On a related note, when I tried checking one of the boxes and posting the record, I received an error from MySQL that 'TRUE' is not a valid values (since the constant was introduced in 4.1).
Thanks,
Don