Find String Length / Character Length

Introduction#

To get length of “character varying”, “text” fields, Use char_length() or character_length().

Example to get length of a character varying field

Example 1, Query: SELECT char_length('ABCDE')

Result:

5

Example 2, Query: SELECT character_length('ABCDE')

Result:

5