List:General Discussion« Previous MessageNext Message »
From:Russ Davies Date:February 6 2001 9:42pm
Subject:Re: Boolean Datatype
View as plain text  
Enum would allow me to have two values such as 'True' and 'False' ?
The problem is when I pass in this SQL statement to mySQL:

INSERT INTO tableName (fieldName) VALUES (True);

-mySQL does not recognise the word True - it would need to be in quotes,
which means changes in the code on the web server. It would mean passing in
a string instead of a boolean. This is what I'm trying to avoid.
True and False are not keywords in mySQL. Would there be any way I could
perhaps make them so (giving them values of 1 and 0 respectively would solve
my problem completely).
Thanks in advance for your efforts,
Russ Davies


----- Original Message -----
From: "Matt Friedman" <matt@stripped>
To: "Russ Davies" <russ@stripped>; "MySQL List" <mysql@stripped>
Sent: Tuesday, February 06, 2001 9:11 PM
Subject: Re: Boolean Datatype


> Try using enum in mysql. That might help you out a bit.
>
> Matt Friedman
> Spry New Media
> http://www.sprynewmedia.com
> Lead Programmer/Partner
> email: matt@stripped
> phone: 250 744 3655
> fax: 250 370 0436
>
>
> ----- Original Message -----
> From: "Russ Davies" <russ@stripped>
> To: "Oson, Chris M." <CHRIS.M.OSON@stripped>; <mysql@stripped>
> Sent: Tuesday, February 06, 2001 12:45 PM
> 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-matt=daart.ca@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