TO_BLOB()

Scalar. Converts a given string to a BLOB value.

Syntax

TO_BLOB( value )
Data Types

Return

value

BLOB

String

Blob

Example

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

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