MySQL TINYINT as data option for checkbox

Post Reply
fbachofner
User
Posts: 70

MySQL TINYINT as data option for checkbox

Post by fbachofner »

MySQL has bool and boolean as synonyms for TINYINT.

As such, it is typical for TINYINT to be used for booleans (i.e. 1 or 0 = true or false) in MySQL databases.

PHPMaker and your other products support checkboxes with enum, but NOT with TINYINT.

Please consider adding TINYINT support for checkbox input control.

Thank you.


fbachofner
User
Posts: 70

Post by fbachofner »

Could PHPMaker please support TINYINT / BIT / BOOL in MySQL db's in the future?

There is a succinct article as to the various problems with ENUMs titled: "8 Reasons Why MySQL's ENUM Data Type Is Evil".

Two fairly major issues with ENUMs (to me) is that they are not portable to other DBs and they grossly violate DRY principles.

Thanks for your consideration.


Post Reply