i have an issue with garbled characters in query result from heidi, but the result of the query executed directly in shell is correct. Could you please help me out wit this?
Best regards, lukasz
Welcome to the world of encoding problems :)
I suppose your shell connection uses the charset defined as
character_set_server, which is
latin1 according to your variables screenshot. HeidiSQL always tries to set utf8mb4, which seems also working. So I guess Heidi shows the correct values if you fire
SET NAMES latin1;, before querying that table? Just guessing, that's not yet a solution.
Can you create a minimal dump file with mysqldump, and send it via mail to me? Mail address can be found on the imprint page.
Please login to leave a reply, or register at first.