SQL:1999
Encyclopedia
SQL:1999 was the fourth revision of the SQL
database
query language
. The latest revision of the standard is SQL:2008.
, IBM DB2
) do not support it as a column type, variable type or allow it in the results set. MySQL
interprets "BOOLEAN" as a synonym for TINYINT (8-bit signed integer).
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:- SQL/Framework ISO/IEC 9075-1:1999
- SQL/Foundation ISO/IEC 9075-2:1999
- SQL/CLI : an updated definition of the extension Call Level Interface, originally published in 1995, also known as CLI-95 ISO/IEC 9075-3:1999
- SQL/PSM : an updated definition of the extension Persistent Stored Modules, originally published in 1996, also known as PSM-96 ISO/IEC 9075-4:1999
- SQL/Bindings ISO/IEC 9075-5:1999
Boolean data types
The SQL:1999 standard calls for a Boolean type, but many commercial SQL Servers (Microsoft SQL Server 2005, Oracle 9iOracle 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).