On Mon, Nov 24, 2003 at 02:49:12PM -0700, Jeff Mathis wrote:
: 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.
The bigger problem I've had with ENUMs as strings is that if you
insert a value that isn't one of your ENUM values (say someone
inserts a '2' instead of a '0' or '1', a blank string ('') is
entered instead. That's no better than someone actually entering
a '2'.
MySQL, SQL, query, etc.
* Philip Molter
* Texas.Net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
