maybe one more particle of information is that enums are actually strings, not numbers, so you may have to do a conversion somewhere. this is a pain for us, so we use tiny ints.
jeff "Mike [tmw]" wrote: > > 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] -- Jeff Mathis, Ph.D. 505-955-1434 The Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6 http://www.predict.com Santa Fe, NM 87505 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
