Binary Datatypes


Binary datatypes are used to store all sorts of data (even binary information), such as graphic images, multimedia, and word processor documents (see Table D.4).

Table D.4. Binary Datatypes

Datatype

Description

BLOB

Blob with a maximum length of 64K.

MEDIUMBLOB

Blob with a maximum length of 16MB.

LONGBLOB

Blob with a maximum length of 4GB.

TINYBLOB

Blob with a maximum length of 255 bytes.


Note

Datatypes in Use If you would like to see a real-world example of how different databases are used, see the sample table creation scripts (described in Appendix B, "The Example Tables").





MySQL Crash Course
MySQL Crash Course
ISBN: 0672327120
EAN: 2147483647
Year: 2004
Pages: 214
Authors: Ben Forta

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net