Yer, that or 0/1 in an integer field -----Original Message----- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 4:06 PM To: CF-Community Subject: RE: MySQL help needed
> Sorry for the technical post but I need some help with > creating a table in > MySQL. Does anyone know if there is an equivilent datatype > to the MS SQL > bit data type? I need to store true or false data in my database. http://www.onlamp.com/pub/a/onlamp/2001/09/13/aboutSQL.html mySQL doesn't have a boolean data type Why not use one character and just put "Y" or "N" into it? Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 F: +44 (0)20 8686 7911 An ISO9001 registered company. ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
