Amazon Redshift introduces new OCTET_LENGTH Function
You can now use OCTET_LENGTH to count the number of bytes (octets) in a specified string.
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.