Re: Yes or No

Hi, MySQL doesn't support this kind of fields - if you want to have a field that have only two values like 0/1 you should use char(1) or enum(0,1). Dobromir Velev -----Original Message----- From: Bartek Pawlik <pawlikb1@poczta.onet.pl> To: jord@theinternetone.co.uk <jord@theinternetone.co.uk>; php-db@lists.php.net <php-db@lists.php.net> Date: Tuesday, October 02, 2001 12:57 PM Subject: Odp: [PHP-DB] Yes or No >Use boolean field, it takes only values Yes/No, 0/1, True/False. > >Bartek Pawlik >Poland > > >----- Original Message ----- >From: Jordan Elver <jord@theinternetone.co.uk> >To: MySQL Mailing List <mysql@lists.mysql.com>; PHP DB Mailing List ><php-db@lists.php.net> >Sent: Tuesday, October 02, 2001 11:23 AM >Subject: [PHP-DB] Yes or No > > >> Hi, >> If I wanted to define a table to have a cloumn which is either yes or no >for >> example. Would it be better to use a single char (0 or 1), or can I use an >> enum (I find them more friendly ;)). >> >> Could you offer some advice? >> >> Thanks, >> >> Jord >> -- >> Jordan Elver >> Web Developer >> The InternetOne UK Ltd >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net >> For additional commands, e-mail: php-db-help@lists.php.net >> To contact the list administrators, e-mail: php-list-admin@lists.php.net >> > > > >-- > >Zagraj z finalistkami >Miss Polonia [ http://miss.onet.pl/start.html ] > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net >For additional commands, e-mail: php-db-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net > >