How to count the number of characters of a giving string using the CHAR_LENGTH() function?

CHAR_LENGTH(string) is a MySQL built-in function that returns the number of characters of a giving string. For example:

SELECT CHAR_LENGTH('dba.FYIcenter.com');
  -- +----------------------------------+
  -- | CHAR_LENGTH('dba.FYIcenter.com') |
  -- +----------------------------------+
  -- |                               17 |
  -- +----------------------------------+

Reference information of the CHAR_LENGTH() function:

CHAR_LENGTH(str): num
  Returns the length of the string str, measured in code points. A
  multibyte character counts as a single code point. This means that, for
  a string containing two 3-byte characters, LENGTH() returns 6, whereas
  CHAR_LENGTH() returns 2.

Arguments, return value and availability:
  str: Required. The given string to count the number of characters for.
  num: Return value. The number of characters in the given string.
  Available since MySQL 4.0.

Related MySQL functions:

• CHARACTER_LENGTH() - Synonym for CHAR_LENGTH()
• CHAR_LENGTH() - Number of Characters
• LENGTH() - Number of Bytes in String
• BIT_LENGTH() - Number of Bits in String

⇒ CHARACTER_LENGTH() - Synonym for CHAR_LENGTH()

⇐ CHAR() - Building String from Byte Values

⇑ MySQL Functions on Character String Values

⇑⇑ MySQL Function References