Boolean data type

« Back to Glossary Index

Generalities about Boolean Data Type
– Programming languages like Pascal and Java have a built-in Boolean data type.
– Comparison operators like ‘and’ are defined to return a Boolean value.
– Conditional and iterative commands are used to test Boolean-valued expressions.
– Some languages like C90 and Lisp represent truth values using other data types.
– Booleans can be implemented as numerical variables with one binary digit or as bit strings of length one.

Boolean Data Type in Programming Languages
– Fortran:
– The first versions of FORTRAN had no logical values or operations.
– FORTRAN IV introduced a Boolean data type, logical literals, and logical operators.
– FORMAT statements in FORTRAN have specific format descriptors for parsing or formatting logical values.
– Later languages like Modula, Ada, and Haskell adopted the Boolean data type derived from FORTRAN.
– FORTRAN uses a BIT(1) representation for Boolean values.
– C, C++, Objective-C, AWK:
– Initial implementations of C did not have a Boolean type, using integers instead.
– ANSI C added enumerated types, allowing programmers to define their own Boolean types.
– Standard C introduced the _Bool type, which can be used with the bool name and true/false constants.
– C++ has a separate bool data type with automatic conversions from scalar and pointer values.
– Objective-C has a separate BOOL data type, but can also use the _Bool type from C.
– PL/I:
– PL/I does not have a Boolean data type.
– Comparison operators in PL/I generate BIT(1) values, with 0B representing false and 1B representing true.
– Operations on PL/I BIT(1) values are performed on each bit.
– The element-expression of an IF statement in PL/I is true if any bit is 1.
– Rexx:
– Rexx does not have a Boolean data type.
– Comparison operators in Rexx generate 0 or 1, with 0 representing false and 1 representing true.
– Rexx operands must be 0 or 1 for comparison operators.
– Tcl:
– Tcl does not have a separate Boolean type.
– Like in C, integers 0 (false) and 1 (true) are used in Tcl.
– Tcl expressions that evaluate to 1 are considered true.

Introduction and Implementation of BOOLEAN data type in SQL:1999
– SQL:1999 standard introduced BOOLEAN data type as an optional feature.
– Introduced IS (NOT) TRUE, IS (NOT) FALSE, and IS (NOT) UNKNOWN operators.
– SQL BOOLEAN behaves like Booleans in other languages, storing TRUE and FALSE values.
– Nullable BOOLEAN can have the special null value.
– SQL standard defines three literals for BOOLEAN type: TRUE, FALSE, and UNKNOWN.
– Few major SQL systems implement the BOOLEAN feature as of 2012.
– Firebird and PostgreSQL are exceptions, with PostgreSQL using NULL instead of UNKNOWN.
– Microsoft SQL Server does not support BOOLEAN, using BIT data type as a workaround.
– Microsoft Access also uses BIT data type instead of BOOLEAN.
– PostgreSQL has a distinct BOOLEAN type as in the standard.

Treatment of BOOLEAN values in different SQL systems
– Microsoft SQL Server does not support BOOLEAN as a standalone data type.
– Microsoft Access represents TRUE as 1 and does not support the Null tri-state.
– PostgreSQL allows storing predicates directly into a BOOLEAN column.
– MySQL treats BOOLEAN as an alias of TINYINT(1), with non-zero integers considered true.
– Tableau Software has a BOOLEAN data type with True and False literals.

BOOLEAN representation in Forth programming language
– Forth does not have a Boolean type, using regular integers for true and false.
– Value 0 represents false, while -1 represents true in Forth.
– Forth uses one set of logical operators for both mathematical calculations and conditions.

Related topics and references:
– Boolean differential calculus, flag programming, Shannons expansion, three-valued logic, and true/false commands for shell scripting are related topics.
– References include books, programming language documentation, and online tutorials for various languages and SQL systems.

Boolean data type (Wikipedia)

In computer science, the Boolean (sometimes shortened to Bool) is a data type that has one of two possible values (usually denoted true and false) which is intended to represent the two truth values of logic and Boolean algebra. It is named after George Boole, who first defined an algebraic system of logic in the mid 19th century. The Boolean data type is primarily associated with conditional statements, which allow different actions by changing control flow depending on whether a programmer-specified Boolean condition evaluates to true or false. It is a special case of a more general logical data type—logic does not always need to be Boolean (see probabilistic logic).

« Back to Glossary Index

Submit your RFP

We can't wait to read about your project. Use the form below to submit your RFP!

Gabrielle Buff
Gabrielle Buff

Just left us a 5 star review

Great customer service and was able to walk us through the various options available to us in a way that made sense. Would definitely recommend!

Stoute Web Solutions has been a valuable resource for our business. Their attention to detail, expertise, and willingness to help at a moment's notice make them an essential support system for us.

Paul and the team are very professional, courteous, and efficient. They always respond immediately even to my minute concerns. Also, their SEO consultation is superb. These are good people!

Paul Stoute & his team are top notch! You will not find a more honest, hard working group whose focus is the success of your business. If you’re ready to work with the best to create the best for your business, go Stoute Web Solutions; you’ll definitely be glad you did!

Wonderful people that understand our needs and make it happen!

Paul is the absolute best! Always there with solutions in high pressure situations. A steady hand; always there when needed; I would recommend Paul to anyone!

Vince Fogliani

The team over at Stoute web solutions set my business up with a fantastic new website, could not be happier

Steve Sacre

If You are looking for Website design & creativity look no further. Paul & his team are the epitome of excellence.Don't take my word just refer to my website ""that Stoute Web Solutions created.This should convince anyone that You have finally found Your perfect fit

Jamie Hill

Paul and the team at Stoute Web are amazing. They are super fast to answer questions. Super easy to work with, and knows their stuff. 10,000 stars.

Paul and the team from Stoute Web solutions are awesome to work with. They're super intuitive on what best suits your needs and the end product is even better. We will be using them exclusively for our web design and hosting.

Dean Eardley

Beautifully functional websites from professional, knowledgeable team.

Along with hosting most of my url's Paul's business has helped me with website development, graphic design and even a really cool back end database app! I highly recommend him as your 360 solution to making your business more visible in today's social media driven marketplace.

I hate dealing with domain/site hosts. After terrible service for over a decade from Dreamhost, I was desperate to find a new one. I was lucky enough to win...

Paul Stoute has been extremely helpful in helping me choose the best package to suite my needs. Any time I had a technical issue he was there to help me through it. Superb customer service at a great value. I would recommend his services to anyone that wants a hassle free and quality experience for their website needs.

Paul is the BEST! I am a current customer and happy to say he has never let me down. Always responds quickly and if he cant fix the issue right away, if available, he provides you a temporary work around while researching the correct fix! Thanks for being an honest and great company!!

Paul Stoute is absolutely wonderful. Paul always responds to my calls and emails right away. He is truly the backbone of my business. From my fantastic website to popping right up on Google when people search for me and designing my business cards, Paul has been there every step of the way. I would recommend this company to anyone.

I can't say enough great things about Green Tie Hosting. Paul was wonderful in helping me get my website up and running quickly. I have stayed with Green...