Garbled characters in query result

2 posts
lukasz.bar's profile image lukasz.bar posted 4 years ago in General Permalink

Hello,

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

3 attachment(s):
  • fromheidi
  • fromdb
  • characterset
10137 posts
ansgar's profile image ansgar posted 4 years ago Permalink

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.

2 posts
lukasz.bar's profile image lukasz.bar posted 4 years ago Permalink

Thank you ansgar for your reply. Unfortunately, after executing "SET NAMES latin1" and next my query, the result is garbled still... I'm really lost in those encoding meanders :)

1 attachment(s):
  • characterlatin
10137 posts
ansgar's profile image ansgar posted 4 years ago Permalink

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.