Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateData types and subtypes → BLOB data type
Firebird Home Firebird Home Prev: BIGINT data typeFirebird Documentation IndexUp: Data types and subtypesNext: New character sets

BLOB data type

Changed in: 2.0

Description: Several enhancements have been implemented for text BLOBs:

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
)
Prev: BIGINT data typeFirebird Documentation IndexUp: Data types and subtypesNext: New character sets
Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateData types and subtypes → BLOB data type