Why does LENGTH(GROUP_CONCAT(`text`)) count wrong?

Question

SQL

SELECT LENGTH(GROUP_CONCAT(`summary`)) FROM `manga` WHERE `id` > 922 GROUP BY ''

gives out 34028, but actually 18678 characters with spaces.

Answer 1

length returns the number of bytes in the string
. And you need char_length , which returns the number of characters.