octet_length function

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

Syntax 

octet_length(expr)

Arguments

  • expr: A STRING or BINARY expression.

Returns

An INTEGER.

Examples 

> SELECT octet_length('Spark SQL');
 9
> SELECT octet_length('μ„œμšΈμ‹œ');
 9