Counting characters in a literal

Question

Accepted Answer

LENGTH returns the number of characters in a string. 'Hello' has 5 characters. In PostgreSQL, LENGTH and CHAR_LENGTH are interchangeable for text. For byte-length of multi-byte UTF-8 strings, use OCTET_LENGTH instead.