This topic is locked

Problem with Binary field in PHPR 8.0

7/30/2015 5:07:50 AM
PHPRunner General questions
J
jacekq author

Hello,
I've defined a simple mysql table:

CREATE TABLE test (

id smallint(5) unsigned NOT NULL AUTO_INCREMENT,

name varchar(50) COLLATE utf8_polish_ci NOT NULL,

active binary(1) DEFAULT NULL,

visible tinyint(1) DEFAULT NULL,

PRIMARY KEY (id)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci


It's not possible to setup field active as a checkbox or any other field type on Visual Editor screen.
The field visible behaves OK.
I have similar problems with mysql views that contains such type of fields.
Regards

Jacek

Sergey Kornilov admin 7/30/2015

I would suggest using tinyint field for checkbox purposes.