This data type has normal column functionality except for the following exceptions:
A column of data type BLOB is not a valid column name in a CREATE INDEX statement.
When issuing a CREATE TABLE statement, a valid data type for the column definitions is BLOB. However, BLOB does not allow the column constraints of PRIMARY KEY, FOREIGN KEY, UNIQUE, REFERENCES, and CHECK.
The VALUES option on the INSERT statement is not valid for the BLOB data type.
In a SELECT statement, a WHERE, GROUP BY, HAVING, or ORDER BY clause cannot use a column of data type BLOB.
A column of data type BLOB is not a valid column name in a CREATE INDEX statement.