SQL:1999
From Wikipedia, the free encyclopedia
This article is about SQL:1999, a revision of the SQL standard. For more information about SQL, see the main SQL article.
SQL:1999 was the fourth revision of the SQL database query language. The latest revision of the standard is SQL:2008.
Contents |
[edit] 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:[1]
- 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
[edit] Boolean data types
The SQL:1999 standard calls for a Boolean type[2], but many commercial SQL Servers (Microsoft SQL Server 2005, Oracle 9i, 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).[3]
[edit] Notes
- ^ Lans 2007, p.23.
- ^ ISO/IEC 9075-2:1999 section 4.6 Boolean types
- ^ http://dev.mysql.com/doc/refman/5.0/en/other-vendor-data-types.html
[edit] References
- Lans, Rick F. van der (2007). SQL for MySQL developers: a comprehensive tutorial and reference. Upper Saddle River, NJ: Addison Wesley. pp. vii-1004. ISBN 9780131497351.
[edit] External links
|
|||||||||||
 |
This programming language-related article is a stub. You can help Wikipedia by expanding it. |
 |
This database-related article is a stub. You can help Wikipedia by expanding it. |
