> 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. ********************************************************************** ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
