Boolean fields in MARIADB 10.4.11

Topic: Boolean fields in MARIADB 10.4.11 (Read 1608 times) previous topic - next topic

Boolean fields in MARIADB 10.4.11

January 07, 2020, 02:30:37 AM

Hi

I'm testing phprad anche I'm getting serious troubles with boolean fields
according to documentation BOOL fields in Maria DB are TINYINT(1)
actually PHPAD do not read correctly boolean values

the only way I've got to make bool fields working is defining them as BUTTONS ansd manually setting values and labels to 1,0 and True,False (o active,NotActive)

I need to use checkbox instead of Button fields, but if I set boolean fields as checkBox value are not read acorrectly and updates are not done !

please help!
Thanks

Re: Boolean fields in MARIADB 10.4.11

Reply #1 – March 22, 2020, 05:10:04 AM

I would like to second this for a fix please. Right now a checkbox only replies true for checked and ' ' for not checked. Our databases require a tinyint(1) for our boolean value. This is necessary so that a SELECT * FROM table WHERE column = TRUE or FALSE is used. I have triggers that depend on this to be the case.

Thank you.

Re: Boolean fields in MARIADB 10.4.11

Reply #2 – February 26, 2022, 08:39:55 AM

I solved this problem using varchar in our mysql database, it seems that phprad are using string values when you use checkbox or radiobuttons, hope this helps to someone