char(1) default to either 0 or 1. I do not believe that SQL93 has a boolean data type nor a standard for implementing it.
=C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -----Original Message----- From: Michael Ivanyo [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 10:57 PM To: [EMAIL PROTECTED] Subject: Enum Type and the ANSI SQL Standard I am designing a database using MySql and need a column that can hold a boolean value of T or F. I am considering both the enum type and char type. I would like to know if the enum type is a standard type as defined by the ANSI SQL standard. --Michael __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
