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 <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> >To: MySQL Mailing List <[EMAIL PROTECTED]>; PHP DB Mailing List ><[EMAIL PROTECTED]> >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: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> To contact the list administrators, e-mail: [EMAIL PROTECTED] >> > > > >-- > >Zagraj z finalistkami >Miss Polonia [ http://miss.onet.pl/start.html ] > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]