The use of group_concat will stil MariaDB stored procedure-CodePudding

Directly use the SELECT GROUP_CONCAT (DISTINCT username) FROM testlog; The query results will not appear garbled,
But when used in the process of storage will be garbled words
The BEGIN
DECLARE sNameStr VARCHAR (100);
The SELECT GROUP_CONCAT (DISTINCT username) INTO sNameStr FROM testlog;
INSERT INTO test (TSTR) VALUES sNameStr;
END $$

Tried to use the convert character set conversion was carried out on the field, or not, what is the way to solve?
Thank you all for the warrior

CodePudding user response:

Your testlog and use different code set the test?

CodePudding user response:

Check the character set,