set names latin1; create table group_concat_test (id int, name varchar(20)) DEFAULT CHARSET=utf8; insert into group_concat_test (id, name) values (1, "óra"); insert into group_concat_test (id, name) values (2, "óra"); select * from group_concat_test; select group_concat(name) from group_concat_test; #select b.id, repeat(b.name, 2) from group_concat_test a, group_concat_test b group by b.id; select b.id, group_concat(b.name) from group_concat_test a, group_concat_test b group by b.id;