DuckDB function octet_length

• octet_length(blob = BLOB): Number of bytes in blob.

• octet_length(bitstring = BIT): Returns the number of bytes in the bitstring.

Usage

octet_length(blob)

Arguments

blob

BLOB

Value

BIGINT

Overloads

• octet_length(blob = BLOB)

• octet_length(bitstring = BIT)

SQL examples

octet_length('\xAA\xBB'::BLOB)
octet_length('1101011'::BITSTRING)

See also

Other blob: decode(), encode(), from_base64(), hex(), md5(), md5_number(), or–or, repeat(), sha1(), sha256(), to_base64(), unbin(), unhex()