Amazon Redshift introduces new OCTET_LENGTH Function

Posted on: Aug 23, 2017

You can now use OCTET_LENGTH to count the number of bytes (octets) in a specified string.

Redshift also provides LENGTH (synonym of LEN), which is different than OCTET_LENGTH in that it returns the actual number of characters in multi-byte strings, not the number of bytes.

OCTET_LENGTH Function is available in all regions.