CHAR_LENGTH / CHARACTER_LENGTH

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Returns the number of characters in a string.

1char_length(<string>)
2character_length(<string>)

• <string>: The string to measure.

Returns an integer representing the number of characters in the string.

• Counts characters, not bytes (important for multi-byte UTF-8 characters).
• The char_length and character_length functions are equivalent.

Get the character count of a string.

1SELECT char_length('jose') AS result;

Returns 4.

• String Types