Posted by ZeldorBlat on 09/14/07 14:24

On Sep 14, 6:50 am, Pugi! <pugin...@gmail.com> wrote:
> I have a table with an ENUM row.
> If I insert a new row (using PHP5, MySQL5 and PDO for database
> connections) with a value that is not in the ENUM list, no error, no
> warning, no exception ... The row is inserted but the field where
> normally one of the values of the ENUM list should be is empty even if
> it is NOT NULL.
>
> How can I enforce the ENUM ?
>
> Pugi!

I looked in the manual for you and found this information:

<http://dev.mysql.com/doc/refman/5.0/en/constraint-enum.html>

• Next in forum: Re: Unique constraint for the columns does not work when one of values is null.
• Prev in forum: Re: How to enforce an ENUM ?
• Thread view: Re: How to enforce an ENUM ?

[Reply to this message]