Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Garbled characters in query result's profile image posted 1 month ago in General Permalink


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
ansgar's profile image ansgar posted 1 month 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.'s profile image posted 1 month 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
ansgar's profile image ansgar posted 1 month 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.