Use the data type BOOL which takes a 1 or 0 character or use CHAR and then you can use Y or N for Yes/No.
Regards, 'Gbamila ----- Original Message ----- From: "Tony Roberts" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 08, 2002 12:26 PM Subject: True/False > I am new to MySQL and I am attempting a new project to help me learn. > > I the past I have used a Boolean data type for True/False, Yes/No type data. > > What data type should be used to achieve the storage of this type of data in > MySQL? > > I have bought the reference manual (a good buy IMHO) but so far can't find > the answer. > > Regards > > > Tony Roberts > Mailbox Solutions Ltd > [EMAIL PROTECTED] > 01777 700 600 > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.389 / Virus Database: 220 - Release Date: 16/09/02 > > > > > --------------------------------------------------------------------- > 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
