OCTET_LENGTH

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Returns the number of bytes in a string.

1octet_length(<string>)

• <string>: The string to measure.

Returns an integer that represents the number of bytes in the string.

• For UTF-8 encoded strings, multi-byte characters contribute more than one byte each.
• This function differs from char_length, which counts characters.

Get the byte length of a string.

1SELECT octet_length('jose') AS result;

Returns 4 (4 ASCII characters, 1 byte each).

• String Types