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
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
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>