Re: TINYINT(1) vs ENUM?

[Mike [tmw]]

I always gone with ENUMs b/c TINYINT(1) still allows you to insert a '2' 
into the field and the last idiot at my current job actually used '0' 
for 'true' in a some fields in some tables.

I believe both would use 1 byte.

Mike

Paul Fine wrote:

Normally for a column with 2 possible values, I would use TINYINT(1) and
programmatically assign a value (ie. Yes/No) to 0/1. I assume that this is
the "correct: way?


Now how about using ENUM instead? Is there any difference in overhead?



Thanks!

 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]