Gossamer Forum
Home : Products : Gossamer Forum : Testing Forum :

MySQL Problem

Quote Reply
MySQL Problem
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.
Quote Reply
Re: [Anonymous] MySQL Problem In reply to
Hmm looks like this was a bug in mysql 3.23.54

Upgrading to 3.23.58 fixed the problem.