First I new at this.. I'm following a tutorial from the frugal computer guy on building a filter for a search form. Created the table, entered the first field no problems.. Tried to enter a field type as boolean ( Yes/No[BOOL] ) set the length to 1 and default value to no.. Save the table and the field type changes to Tiny Integer [TINYINT] , length to 3 and default value to false..
Am I doing something wrong or is this a bug ??
Thanks Bob
Hello @bobde, i checked in my own table and the field length for a YES/NO (Boolean) field is set to 0 ( ZERO ).
Please try if setting field length back to zero solves it.
Hm, according to this page the actual length of a Boolean is defined as 1 byte, and also a TINYINT should be 1 byte. In this post] it is confirmed by @Ratslinger that the Boolean field length is set to 0 and stlll works without problems.
Asked: 2017-08-22 04:00:13 +0100
Seen: 360 times
Last updated: Aug 22 '17
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
