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.