Skip to main content

VARBINARY Type

Represents variable length byte sequence values.

Syntax

VARBINARY

Limits

The type supports byte sequences of any length greater or equal to 0.

VARBINARY Length

VARBINARY can have defined maximum lengths of 1 to 65000.

Literals

VARBINARY literals are defined with a x prefix (case in-sensitive) and can only use the following characters: [0-9] and [A-F]. Literals must also contain an even number of hexits.

-- Outputs in base64 for these examples.
> SELECT x'FF'
'/w=='
             
> SELECT x'01'
'AQ=='