SQL:1999
Encyclopedia
SQL:1999 was the fourth revision of the SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....

 database
Database
A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality , in a way that supports processes requiring this information...

 query language
Query language
Query languages are computer languages used to make queries into databases and information systems.Broadly, query languages can be classified according to whether they are database query languages or information retrieval query languages...

. The latest revision of the standard is SQL:2008.

Summary

The SQL:1999 standard, also known as SQL3, was published in 1999. Unlike previous editions, the standard's name used a colon instead of a hyphen for consistency with the names of other ISO standards. SQL:1999 has several parts:

Boolean data types

The SQL:1999 standard calls for a Boolean type, but many commercial SQL Servers (Microsoft SQL Server 2005, Oracle 9i
Oracle Database
The Oracle Database is an object-relational database management system produced and marketed by Oracle Corporation....

, IBM DB2
IBM DB2
The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on Unix , Linux, IBM i , z/OS and Windows servers. DB2 also powers the different IBM InfoSphere Warehouse editions...

) do not support it as a column type, variable type or allow it in the results set. MySQL
MySQL
MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...

interprets "BOOLEAN" as a synonym for TINYINT (8-bit signed integer).
The source of this article is wikipedia, the free encyclopedia.  The text of this article is licensed under the GFDL.
 
x
OK