BLOB data type

Changed in: 2.0

Description: Several enhancements have been implemented for text BLOBs:

DML COLLATE clauses are now supported.
Equality comparisons can be performed on the full BLOB contents.
Character set conversions are possible when assigning a BLOB to a BLOB or a string to a BLOB.

When defining binary BLOBs, the mnemonic binary can now be used instead of the integer 0.

Examples:

select NameBlob from MyTable
  where NameBlob collate pt_br = 'João'

create table MyPictures (
  id int not null primary key,
  title varchar(40),
  description varchar(200),
  picture blob sub_type binary
)