encoding error

[expired user #4516]'s profile image [expired user #4516] posted 14 years ago in General Permalink
cyrillic comments looks good in database view
http://img42.imageshack.us/img42/8189/59913018.jpg
but in table view are in wrong encoding
http://img18.imageshack.us/img18/4774/51016874.jpg
ansgar's profile image ansgar posted 14 years ago Permalink
I just tried to fetch the comment from a SHOW TABLE STATUS result, like it is done on the "Database" tab. But, then I'd reintroduce an older bug which cuts off the comment on specific tables. I'm afraid that renders this problem unsolvable...
[expired user #4516]'s profile image [expired user #4516] posted 14 years ago Permalink
i`ve just tested the program on the db, that was previously created by phpmyadmin or previous version of heidi
the comments were saved and rendered correctly
afterwards I`ve recreated some tables with comments attached - and they were rendered incorrectly.
so this bug seems to be introduced not very long ago - less then 2 months.
hope this will help. Thank you
ansgar's profile image ansgar posted 14 years ago Permalink
It is not a bug in HeidiSQL, it is the server returning a corrupted CREATE TABLE statement. Please test by firing a
SHOW CREATE TABLE yourtable
[expired user #4516]'s profile image [expired user #4516] posted 14 years ago Permalink
well now it seems that all is fixed, like it was not such a problem... I don`t understand whysurprised

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