• ⌂ Text
• Functions
  • CHAR_LENGTH()
  • CONCAT()
  • ENUM()
  • FIND_ALL_IN_SET()
  • FIND_ANY_IN_SET()
  • FIND_IN_SET()
  • INSTR()
  • LEFT()
  • LENGTH()
  • LOCATE()
  • LOWER()
  • LPAD()
  • LTRIM()
  • MATCHES()
  • ORD()
  • REVERSE()
  • RIGHT()
  • RPAD()
  • RTRIM()
  • SUBSTR()
  • SUBSTRING()
  • TRIM()
  • UPPER()

CHAR_LENGTH()

Returns the number of characters in a string.  Multibyte characters count as a single character.

Prototype

int CHAR_LENGTH(string str)

Parameters

• str - String or expression to evaluate to a string.

Return

Number of characters in the string.

Example

SELECT OID, CHAR_LENGTH(Username) AS UsernameLength FROM User

Related

LENGTH()

• < Text
• CONCAT() >