Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Language Elements : Data types : Bit string data types : Language support for BLOB
Language support for BLOB
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.