Categories:

String & Binary Functions (General)

OCTET_LENGTH¶

Returns the length of a string or binary value in bytes. This will be the same as LENGTH for ASCII strings and greater than LENGTH for strings using Unicode code points. For binary, this is always the same as LENGTH.

Syntax¶

OCTET_LENGTH(<string_or_binary>)
Copy

Arguments¶

string_or_binary

The string or binary value for which the length is returned.

Examples¶

SELECT OCTET_LENGTH('abc'), OCTET_LENGTH('\u0392'), OCTET_LENGTH(X'A1B2');

---------------------+------------------------+-----------------------+
 OCTET_LENGTH('ABC') | OCTET_LENGTH('\U0392') | OCTET_LENGTH(X'A1B2') |
---------------------+------------------------+-----------------------+
 3                   | 2                      | 2                     |
---------------------+------------------------+-----------------------+
Copy