List:General Discussion« Previous MessageNext Message »
From:Rolf Hopkins Date:February 7 2001 1:14am
Subject:Re: Boolean Datatype
View as plain text  
I am surprised you said that.  There are many programming languages that do
not recognise boolean datatypes.  To define a boolean variable in these
languages, declare a variable as integer then 0 = false and any other number
= true.

In your case, I suggest you could try changing your Access/ASP datatype to
integers instead.  It should still be able to handle normal boolean
comparisons.  Ie "if myboolean then", you shouldn't need to change to "if
myboolean <> 0 then"


----- Original Message -----
From: "Russ Davies" <russ@stripped>
To: "Oson, Chris M." <CHRIS.M.OSON@stripped>; <mysql@stripped>
Sent: Wednesday, February 07, 2001 4:45
Subject: Re: Boolean Datatype


> 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
> > >
> > > ---------------------------------------------------------------------
> > > Before posting, please check:
> > >    http://www.mysql.com/manual.php   (the manual)
> > >    http://lists.mysql.com/           (the list archive)
> > >
> > > To request this thread, e-mail <mysql-thread64373@stripped>
> > > To unsubscribe, e-mail
> > > <mysql-unsubscribe-CHRIS.M.OSON=saic.com@stripped>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > >
> >
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread64398@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-rhopkins=mail.waytech.com.tw@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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