I am working with an NT4.0 platform, mySQL 3.23 and using ASP and myODBC to access my
I was hoping to find a BOOLEAN data type within mySQL which would allow me to pass either
'True' or 'False' in - but it appears there isn't one?
Using 'BOOL' as the column type appears to create a tinyint - taking ranges from (as
usual) -127 to 127.
This is a *real* inconvenience. I can of course change the data from a '1' or a '0' to
True and False on the way in and out of the database, but this is alot of extra coding,
extra work on the part of the script and makes the code a great deal more unreadable. I
really wanted to try mySQL on my personal site - if it is good enough in a development
environment I may then go on to reccomend it to my company, but this seems a bit awkward
and I'm sure I would take criticism if I can't answer this question.
I have searched Google and the mySQL manual for 'boolean datatype' and other similar
Is there a datatype or an easier workaround for this?
Many thanks in advance,