database - MYSQL cuts off part of a string on GROUP BY -

i'm using command create whole table:

insert `odm_rodzice`(`kropkoogonek`, `rodzice`, `rodziceid`, `ilosc`)  select      kropkoogonek,      group_concat(`slowo` separator ', ') rodzice,      group_concat(`rodzic` separator ', ') rodziceid,     count(*) liczba odm_kropkoogonki  left join odm_slownik on odm_kropkoogonki.rodzic = odm_slownik.id odm_kropkoogonki.id = 2000000 group kropkoogonek 

it turned out longest resulting string (260 6-letter words) short , somehow cutted:

select rodzice slownik.`odm_rodzice` kropkoogonek = 'p.....';   gives:  płonne, poznał, polazę, (...) pszona, pełzną, pełzną, pełz

it has 893 letters - while shoud have 1838 (including ', ') , last word incomplete.

column type text.

what doing wrong?

best regards!

you being affected group_concat_max_len (documented here).

the maximum value 1024 bytes. have accented characters, average character length bit more 1 byte.

you can change value larger value , re-run query.