octet_length function

Applies to: Databricks SQL Databricks Runtime

Returns the byte length of string data or number of bytes of binary data.

octet_length(expr)

• expr: A STRING or BINARY expression.

An INTEGER.

> SELECT octet_length('Spark SQL');
 9
> SELECT octet_length('서울시');
 9

• bit_length function
• length function
• char_length function
• character_length function