The following works on windows with mysql 3.23.54:
UPDATE Table SET col = 1;
...where col is ENUM('0', '1')
...however on linux with mysql 3.23.58 the update causes the ENUM error value "0" to be inserted. It refuses to insert 1 unless you quote the number, eg...
UPDATE Table SET col = '1';
....why is this?
Using $sth->execute(1);
...also fails when using placeholders.
UPDATE Table SET col = 1;
...where col is ENUM('0', '1')
...however on linux with mysql 3.23.58 the update causes the ENUM error value "0" to be inserted. It refuses to insert 1 unless you quote the number, eg...
UPDATE Table SET col = '1';
....why is this?
Using $sth->execute(1);
...also fails when using placeholders.