length

Returns the number of bytes in a BLOB or BLOB-backed EVM value such as ADDRESS, BYTES32, UINT256, or INT256.

Example

Local

1
-- Compare variable payload, address, and EVM-word storage widths
2
SELECT
3
length('0x123456'::BYTES) AS payload_bytes,
4
length('0x0000000000000000000000000000000000000000'::ADDRESS) AS address_bytes,
5
length(1::UINT256) AS word_bytes;
6
-- => [{"payload_bytes":3,"address_bytes":20,"word_bytes":32}]
Notebook ready in readonly mode.

API reference

Exact signatures with descriptions, requirements, inputs, returns, and examples.

length(BYTES) #

Returns the byte length of the input BLOB.

Inputs

Name Type Use
value BYTES

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

66 additional overloads
length(ADDRESS) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value ADDRESS

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(BYTES4) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value BYTES4

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(BYTES32) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value BYTES32

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(BYTES256) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value BYTES256

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT160) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT160

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT256) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT256

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT512) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT512

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT160) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT160

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT256) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT256

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT512) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT512

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT24) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT24

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT24) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT24

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT32) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT32

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT32) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT32

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT40) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT40

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT40) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT40

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT48) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT48

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT48) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT48

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT56) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT56

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT56) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT56

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT64) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT64

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT64) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT64

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT72) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT72

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT72) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT72

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT80) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT80

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT80) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT80

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT88) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT88

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT88) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT88

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT96) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT96

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT96) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT96

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT104) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT104

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT104) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT104

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT112) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT112

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT112) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT112

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT120) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT120

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT120) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT120

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UHUGEINT) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UHUGEINT

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(HUGEINT) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value HUGEINT

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT136) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT136

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT136) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT136

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT144) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT144

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT144) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT144

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT152) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT152

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT152) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT152

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT168) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT168

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT168) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT168

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT176) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT176

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT176) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT176

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT184) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT184

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT184) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT184

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT192) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT192

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT192) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT192

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT200) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT200

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT200) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT200

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT208) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT208

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT208) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT208

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT216) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT216

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT216) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT216

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT224) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT224

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT224) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT224

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT232) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT232

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT232) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT232

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT240) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT240

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT240) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT240

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(UINT248) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value UINT248

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

length(INT248) #

Returns the stored byte length of the BLOB-backed EVM alias value.

Inputs

Name Type Use
value INT248

BLOB or BLOB-backed EVM value. The result measures stored bytes, not display characters.

 required positional

Returns

Name Type
bytes BIGINT

Stored byte count. Returns BIGINT byte length. NULL input returns NULL.

Category and tags

Category
EVM utilities
Tag
Bytes
Tag
Blob
Tag
Types