BIT Field not recognized

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
sticcino
User
Posts: 1043

BIT Field not recognized

Post by sticcino »

Hi,

created a BIT field (default value b'0' -- mysql inserted), but in the table, the field does not appear, even though phpmaker recognizes the change.
mysql v: 5.6.12
Field Name: PO_isClosed

to confirm, changed the field from BIT to INT and it appeared in the table

is the default value causing the issue?

Johnny


Webmaster
User
Posts: 9427

Post by Webmaster »

BIT field will be shown under the "Unsupported Fields" tab. If you want a boolean field, use ENUM(1/0) or ENUM(y/n) or ENUM(Y/N).


Post Reply