Skip to Main Content
SQL in a Nutshell, 3rd Edition
book

SQL in a Nutshell, 3rd Edition

by Kevin Kline
November 2008
Intermediate to advanced content levelIntermediate to advanced
591 pages
17h 28m
English
O'Reilly Media, Inc.
Content preview from SQL in a Nutshell, 3rd Edition

SQL2003 and Platform-Specific Datatypes

A table can contain one or many columns. Each column must be defined with a datatype that provides a general classification of the data that the column will store. In real-world applications, datatypes improve efficiency and provide some control over how tables are defined and how the data is stored within a table. Using specific datatypes enables better, more understandable queries and helps control the integrity of the data.

The tricky thing about SQL2003 datatypes is that they do not always map directly to identical implementations in different platforms. Although the various platforms specify “datatypes” that correspond to the SQL2003 datatypes, these are not always true SQL2003 datatypes: for example, MySQL’s implementation of a BIT datatype is actually identical to a CHAR(1) datatype value. Nonetheless, each of the platform-specific datatypes is close enough to the standard to be both easily understandable and job-ready.

The official SQL2003 datatypes (as opposed to platform-specific datatypes) fall into the general categories described in Table 2-8. Note that the SQL2003 standard contains a few rarely used datatypes (ARRAY, MULTISET, REF, and ROW) that are shown only in Table 2-8 and not discussed elsewhere in the book.

Table 2-8. SQL2003 categories and datatypes

Category

Example datatypes and abbreviations

Description

BINARY

BINARY LARGE OBJECT (BLOB)

This datatype stores binary string values in hexadecimal format. Binary string values are ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Effective SQL: 61 Specific Ways to Write Better SQL, First Edition

Effective SQL: 61 Specific Ways to Write Better SQL, First Edition

John L. Viescas, Douglas J. Steele, Ben G. Clothier
SQL in a Nutshell, 4th Edition

SQL in a Nutshell, 4th Edition

Kevin Kline, Regina O. Obe, Leo S. Hsu

Publisher Resources

ISBN: 9780596155322Errata Page