Ask Your Question

Boolean value

asked 2017-08-22 04:00:13 +0100

bobde gravatar image

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-08-22 05:26:38 +0100

librebel gravatar image

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.

edit flag offensive delete link more


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

bobde gravatar imagebobde ( 2017-08-22 14:20:17 +0100 )edit

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.

librebel gravatar imagelibrebel ( 2017-08-22 15:33:31 +0100 )edit

Thank You.. I think I got it .. I've got the search form working.. Thanks Again


bobde gravatar imagebobde ( 2017-08-22 16:07:14 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-08-22 04:00:13 +0100

Seen: 360 times

Last updated: Aug 22 '17