table column string is broken

classe82's profile image classe82 posted 5 years ago in General Permalink

my mysql server character set is UTF-8 but table column comment string is broken when I used the HeidiSQL

I looked into the cause.

this query result is EUC-KR so I can see column comment SHOW CREATE TABLE Table_name;

I've asked a question before. please fix it

https://www.heidisql.com/forum.php?t=24190#p24203

ansgar's profile image ansgar posted 5 years ago Permalink

Using HeidiSQL 10.2, I cannot reproduce that here. See my screenshot.

I'm not sure if I am using the same font as you, at least I did not change it at all.

But even the create code tab shows the right characters.

So, if there's still an issue for you, you need to post more details, and better file it in the bugtracker as a new issue. Please use the latest HeidiSQL build before doing that, and please include server version, and CREATE TABLE code for that table so one can reproduce that.

1 attachment(s):
  • korean-comments

Please login to leave a reply, or register at first.