flag, status, binary, on/off, yes/no, enum, ...

Log from IRC server Freenode (IPv6) channel #SQL.

<me> I'd like to create a specific field and I found this article that describe *exactly* what I want and a proposed solution, however could it be validated ? http://lists.mysql.com/mysql/818
<mrgenixus> you can validate anything you like....?
<me> I'm not sure of the answer and I'd like a second opinion.
* me don't have a choice on the DBMS
<me> so is enum all right ?
<mrgenixus> mysql-itself doesn't support validation... that's a client option, usually. ianadba
<mrgenixus> if you need two values, I'd use TINYINT(1)
<mrgenixus> that will give you 1 or 0 which can be evaluated as such within mysql
<mrgenixus> then you can say SELECT * FROM table WHERE NOT isDeleted... where isDeleted might be your field... useing an enum to do that doesn't work
<me> mrgenixus: thanks :)