Hi,<BR><BR>I see there is no BOOLEAN datatype in mySQL. Is the best way for storing such values to have a CHAR(1) field and store a Y or an N in this field ?<BR><BR>Thanks,<BR><BR>Hal.
and put 0 and 1 for false and true. When you retrieve from recordset, do a boolean conversion ,i.e.<BR>dim x<BR>x = CBool(rs("bool_field"))
I've been looking at this again and I'm not offered a BIT type ??? I've looked at the documentation and can't see anything. I'm still using CHAR(1) for now, can anyone advise please ?<BR><BR>Thanks,<BR>Hal.