Hi,
I've just created some tables that I designed using the MySQL Workbench
Model. However, the database type BOOLEAN which was in my models has been
converted to TINYINT(1); I'm currently running MySQL Version 5.6.2-m5 on
Windows 2008 server.
Any ideas why this has been removed ?
Neil
Hi, Like the link states
For clarity: a TINYINT(1) datatype does NOT ENFORCE a boolean value data
entry. For instance, it's still possible to insert a value of 2 (any
integer up to the TINYINT max value). I personally don't see the added
value of a 'BOOLEAN' synonym type which infact behaves
Hey Neil,
Why not just store it as a TINYINT, that's what I do when I only care
about 0 or 1 values?
On Wed, May 22, 2013 at 2:19 PM, Neil Tompkins neil.tompk...@googlemail.com
wrote:
Hi Shawn
I plan in installing the latest MySQL version tomorrow. Does MySQL not
support Bool eg true
Hi Shawn
I plan in installing the latest MySQL version tomorrow. Does MySQL not
support Bool eg true and false
Neil
On 22 May 2013, at 19:05, shawn green shawn.l.gr...@oracle.com wrote:
Hello Neil,
On 5/22/2013 1:05 PM, Neil Tompkins wrote:
Hi, Like the link states
For clarity: a
Hello Neil,
On 5/22/2013 1:05 PM, Neil Tompkins wrote:
Hi, Like the link states
For clarity: a TINYINT(1) datatype does NOT ENFORCE a boolean value data
entry. For instance, it's still possible to insert a value of 2 (any
integer up to the TINYINT max value). I personally don't see the added
Why not use ENUM with True|False or Y|N Only issue is it doesn't throw
and error of you enter an illegal value but I don't think I've ever
flagged the field as NOT NULL.
On Wed, May 22, 2013 11:32, Darryle Steplight wrote:
Hey Neil,
Why not just store it as a TINYINT, that's what I do when I
suspect (without
proof) that it works the same as it has for more than a decade.
-Original Message-
From: Wm Mussatto [mailto:mussa...@csz.com]
Sent: Wednesday, May 22, 2013 1:57 PM
To: mysql@lists.mysql.com
Subject: Re: Version 5.6.2-m5 Boolean Datatype
Why not use ENUM with True
On 05/22/2013 06:55 PM, Neil Tompkins wrote:
Hi,
I've just created some tables that I designed using the MySQL Workbench
Model. However, the database type BOOLEAN which was in my models has been
converted to TINYINT(1); I'm currently running MySQL Version 5.6.2-m5 on
Windows 2008 server.
2013/05/22 21:17 +, Rick James
In query syntax, TRUE is the same as 1; FALSE is the same as 0.
and UNKNOWN is NULL. (I actually have used a three-state comparison.)
It has been suggested that one who wants a real two-state field use the type
CHAR(0) NULL.
If you have more 'flags',
On 06.02.2001 18:09:36 russ wrote:
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
Many thanks to all for the help on this issue.
I've come to the conclusion the simplest way for me to implement this is to use the
ENUM type with two possible values 'True' and 'False'.
I will convert the VB BOOLEAN type to a string before I enter it.
Thankfully when returning a value from
On 07.02.2001 10:30:15 russ wrote:
Many thanks to all for the help on this issue.
I've come to the conclusion the simplest way for me to implement this is to
use
the ENUM type with two possible values 'True' and 'False'.
I will convert the VB BOOLEAN type to a string before I enter it.
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
manual for 'boolean datatype' and other similar
searches.
Is there a datatype or an easier workaround for this?
Many thanks in advance,
Russ Davies
FROM logInfo2 WHERE boolVars = 'F';
-Original Message-
From: russ [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 9:10 AM
To: [EMAIL PROTECTED]
Subject: Boolean Datatype
Im new to the list, apologies if this has been asked before.
Im developing a backend for a personal site
ris M." [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
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
AM
To: Oson, Chris M.; [EMAIL PROTECTED]
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
pro
"RD" == Russ Davies [EMAIL PROTECTED] writes:
RD Thanks for the suggestion, but this would still mean converting the data
RD type from within ASP (the 'True' type) down to a char ('T') would it not?
then use
ENUM('False','True')
instead. Enum can have any string you want. I personally
efforts,
Russ Davies
- Original Message -
From: "Matt Friedman" [EMAIL PROTECTED]
To: "Russ Davies" [EMAIL PROTECTED]; "MySQL List" [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 9:11 PM
Subject: Re: Boolean Datatype
Try using enum in mysql. That mi
, February 06, 2001 2:44 PM
To: Oson, Chris M.; [EMAIL PROTECTED]
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
to be for an ENUM data type?
Russ Davies
- Original Message -
From: "Vivek Khera" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 9:09 PM
Subject: Re: Boolean Datatype
"RD" == Russ Davies [EMAIL PROTECTED] writes:
RD Thanks for the suggestion, but t
"Russ Davies" [EMAIL PROTECTED]; [EMAIL PROTECTED]
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,
Subject: Re: Boolean Datatype
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
, February 06, 2001 3:56 PM
Subject: Re: Boolean Datatype
http://www.mysql.com/doc/A/d/Adding_functions.html
Could this help him out? Creating a User Defined Function?
Gregg
- Original Message -
From: Russ Davies [EMAIL PROTECTED]
To: Matt Friedman [EMAIL PROTECTED]; MySQL List
[EMAIL
uot; [EMAIL PROTECTED]; [EMAIL PROTECTED]
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 l
25 matches
Mail list logo