TO_BLOB()

Scalar. Converts a given string to a BLOB value.

Syntax

TO_BLOB( value )

Data Types
Return	value
BLOB	String
BLOB	Blob

The following example returns a BLOB based on the input string:

INSERT INTO OutStream
SELECT TO_BLOB('0123456789abcdef') -- BLOB of 8 bytes
FROM ImageData;