List:General Discussion« Previous MessageNext Message »
From:btjones Date:February 6 2001 9:55pm
Subject:Re: Boolean Datatype
View as plain text  
I use True/False fields all the time from MS Access through myODBC.  While
I've not used ASP, it would seem that the functionality would be the same.
If this is the case, then True is represented by -1 and False is
represented by 0.  Simply use the TINYINT that mySQL provides to store
these two values.



"Russ Davies" <russ@stripped> wrote:

I can't do that for 2 reasons :
1] 'True' and 'False' are reserved words in ASP
2] 'True' would then be a variant holding the value 'T' - which would mean
I
could not carry out logical comparisons with the two variants, evaluating
things against True or False.

I have to say after all the reccomendations I received for mySQL, I really
am shocked to find there are no BOOLEAN values/datatypes. Unless I'm
missing
something (and Im happy to admit I probably am) this seems like a very
serious and time consuming omission from the mySQL spec.
If anyone is aware of a solution to this, please email me, I quite like
mySQL but I think I'd probably move to another DBMS rather than spend a
long
time and get messy coding around this problem.

Russ Davies


----- Original Message -----
From: "Oson, Chris M." <CHRIS.M.OSON@stripped>
To: "Russ Davies" <russ@stripped>; <mysql@stripped>
Sent: Tuesday, February 06, 2001 8:02 PM
Subject: RE: Boolean Datatype


> Maybe, but you could define a constant..
>
> CONST TRUE  "T"
> CONST FALSE "F"
>
> INSERT INTO logInfo2 (logID, ipAddress, boolVars) VALUES (null,
> '192.192.192.192', TRUE)
>
> -----Original Message-----
> From: Russ Davies [mailto:russ@stripped]
> Sent: Tuesday, February 06, 2001 11:44 AM
> To: Oson, Chris M.; mysql@stripped
> Subject: Re: Boolean Datatype
>
>
> Thanks for the suggestion, but this would still mean converting the data
> type from within ASP (the 'True' type) down to a char ('T') would it not?
>
> It is more sensical than using 1/0 but still involves the same number of
> processes?
>
> Russ Davies
>
>
>
> ----- Original Message -----
> From: "Oson, Chris M." <CHRIS.M.OSON@stripped>
> To: <russ@stripped>; <mysql@stripped>
> Sent: Tuesday, February 06, 2001 6:36 PM
> Subject: RE: Boolean Datatype
>
>
> > Why not try using ENUM?
> >
> > http://www.mysql.com/doc/E/N/ENUM.html
> >
> > You could setup your table like this:
> >
> > CREATE TABLE logInfo2
> > (
> >     logID           INT NOT NULL UNIQUE,
> >     ipAddress       VARCHAR(20) NOT NULL DEFAULT 'None',
> >     boolVars        ENUM ('T', 'F') DEFAULT 'F'
> > )
> >
> > SELECT ipAddress FROM logInfo2 WHERE boolVars = 'F';
> >
> > -----Original Message-----
> > From: russ [mailto:russ@stripped]
> > Sent: Tuesday, February 06, 2001 9:10 AM
> > To: mysql@stripped
> > Subject: Boolean Datatype
> >
> >
> > Im new to the list, apologies if this has been asked before.
> >
> > Im developing a backend for a personal site (www.russd.com) using
mySQL.
> > The site is hosted on NT4 and has myODBC installed, I have some
database
> > access working, but I'm looking for a way to implement boolean types.
> >
> > Using Access/SQL server I can simple do an insert using SQL like the
> > following (from within ASP):
> >
> > INSERT INTO tblMyTable (booleanField) VALUES (" & myBooleanVariant &
");"
> >
> > Unfortunately, mySQL doesn't appear to have a boolean datatype and
myODBC
> > doesn't seem to convert True/False to 1/0.
> > The best solution I have so far is to use a TINYINT and change the
> > True/False values within my ASP code to 1/0. This isn't perfect
howevere
> as
> > its more code, more work for the server and far less readable. I also
have
> > to cast to boolean when I SELECT data from the mySQL database.
> >
> > Could anyone suggest a better way of implementing this, or am I missing
> > something?
> > I have done a Google search and searched the mySQL manual, but got
> nothing.
> >
> > Many thanks in advance of your efforts.
> > Russ Davies





Thread
Boolean DatatypeRuss Davies6 Feb
RE: Boolean DatatypeChris M. Oson6 Feb
  • Re: Boolean DatatypeRuss Davies6 Feb
    • Re: Boolean DatatypeVivek Khera6 Feb
    • RE: Boolean DatatypeRoger Ramirez6 Feb
  • Re: Boolean DatatypeRuss Davies6 Feb
RE: Boolean DatatypeChris M. Oson6 Feb
  • Re: Boolean DatatypeRuss Davies6 Feb
  • Re: Boolean DatatypeMatt Friedman6 Feb
  • Re: Boolean DatatypeRuss Davies6 Feb
  • Re: Boolean DatatypeGregg Housh6 Feb
  • Re: Boolean DatatypeRolf Hopkins7 Feb
Re: Boolean Datatypebtjones6 Feb
Re: Boolean DatatypeGregg Housh6 Feb
Antwort: Boolean Datatypealexander.skwar7 Feb