SQL:1999

From Wikipedia, the free encyclopedia
Jump to: navigation, search

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]

[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

[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

Personal tools
Namespaces
Variants
Actions
Navigation
Interaction
Toolbox
Print/export
Languages