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.
No joy… Set the length to 0 and as soon as I save it the length changes to 3
Is there a config file for the fields types?
Thanks
Bob
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.
Thank You… I think I got it … I’ve got the search form working…
Thanks Again
Bob