What is the difference between `CHAR_LENGTH()` and `LENGTH()` in MySQL for multibyte character sets?

Question

Advanced SQL Developer — Medium

What is the difference between `CHAR_LENGTH()` and `LENGTH()` in MySQL for multibyte character sets?

Accepted Answer

CHAR_LENGTH() and LENGTH() differ in MySQL for multibyte character sets. CHAR_LENGTH() counts characters, while LENGTH() counts bytes. For UTF-8 multibyte characters like emoji or Chinese, LENGTH() may return more than CHAR_LENGTH() due to the varying byte lengths of each character.