> 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

Reply via email to