K
K
khodos_dmitry2019-12-09 21:25:00
SQL
khodos_dmitry, 2019-12-09 21:25:00

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

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

gives out 34028, but actually 18678 characters with spaces.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
N
neol, 2019-12-09
@neol

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

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question