You could use an integer (0 or 1) or an enum with the values 'y' or 'n'
-----Original Message-----
From: Tony Roberts [mailto:troberts@stripped]
Sent: Friday, November 08, 2002 4:26 AM
To: mysql@stripped
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
troberts@stripped
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 <mysql-thread124396@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-johnmeyer_1978=yahoo.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php