This page is part of the book SQL-99 Complete, Really, by Peter Gulutzan & Trudy Pelzer. The authors have graciously allowed us to reproduce the contents of the book here. Because the book is about the SQL-99 standard, the contents of this and other pages in the book may not directly apply to MariaDB. Use the navigation bar to navigate the book.

In SQL, a binary string, or BLOB, is any arbitrary sequence of zero or more octets that isn't associated with either a Character set or a Collation. A BLOB value may be a <literal>, the value of a parameter or a host language variable or the result of any expression or argument (including a possibly qualified <Column name>) that evaluates to a binary string. BLOBs represent an unknown lump of binary data: the typical use of a BLOB <data type> is to store an image.

Octets in a BLOB are numbered (from left to right) beginning with 1 (the most significant octet). BLOBs are stored in the binary string <data type> BLOB.