OCTET_LENGTH

​

Syntax

​

Scalar

octet_length(value)

​

Arguments

​

Returns

• Type: INT
• Possible values: A nonnegative byte count; zero for an empty value.
• NULL behavior: Returns NULL for NULL input.

​

Properties

​

Units

• Input unit: UTF-8 string or bytes
• Output unit: Bytes
• character_length counts Unicode code points.

​

Examples

​

Typical behavior

SELECT octet_length('josé') AS bytes, octet_length(X'00FF') AS binary_bytes;

​

Text bytes versus binary bytes

SELECT octet_length('é猫') AS text_bytes, octet_length(X'C3A9') AS binary_bytes;