octet_length()

A function returning the number of bytes in the provided parameter

octet_length() is a system function which returns the number of bytes (octets) in the provided parameter.

octet_length() was added in PostgreSQL 6.4.

Usage

octet_length ( text ) → integer

octet_length ( bytea ) → integer

octet_length ( bit ) → integer

Using octet_length() to obtain the number of bytes in a simple ASCII string:

postgres=# SELECT octet_length('ABC');
 octet_length 
--------------
            3
(1 row)

Using octet_length() to obtain the number of bytes in an UTF8 string containing multibyte characters:

postgres=# SELECT octet_length('ほげほげ');
 octet_length 
--------------
           12
(1 row)

Using octet_length() to obtain the number of bytes in a binary string:

postgres=# SELECT octet_length('\xdeadbeef'::bytea);
 octet_length 
--------------
            4
(1 row)