OCTET_LENGTH

Calculates the length of the input string in bytes.

Syntax

OCTET_LENGTH(<expression>)

Parameter	Description	Supported input types
`<expression>`	The string or binary data for which to return the length.	`TEXT`, `BYTEA`

INTEGER

Use the OCTET_LENGTH to find the length of any string in bytes, such as:

SELECT OCTET_LENGTH('🔥');

octet_length int
4

Rows: 1Execution time: 5.21ms

Because the UTF8 encoding of ’🔥’ has the byte sequence 0xF0 0x9F 0x94 0xA5.

⌘I