Bug?

[expired user #9130]'s profile image [expired user #9130] posted 9 years ago in General Permalink
Hi,
I use heidi since the 4th version and it all works up to version 8.3.
But if i try to upgrade to a version greater than 8.3 i can't see the german special character "ä ö ü"
They get replaced by <?> Symbols in the preview and every Query, this break all our data if i save a special character.


-MySQL Servers are locked at 3.23.53 and we can't upgrade
-Collation is not changeable
-Engine is MyISAM

greetings from Germany
ansgar's profile image ansgar posted 9 years ago Permalink
Well, if the collation is wrong and data is stored and read in the same wrong way, then HeidiSQL cannot do much here.

Probably you can try to downgrade the libmysql.dll located in folder where heidisql.exe resides. I have update the used charset from utf8 to utf8mb4 some time ago.
ansgar's profile image ansgar posted 9 years ago Permalink
I did the mentioned update in r4822, so in the previous commit you can find the older library which is probably working for you:
http://sourceforge.net/p/heidisql/code/4821/tree/trunk/out/

Just take care for the right architecture (32/64bit) and rename the file after downloading to libmysql.dll.
[expired user #9130]'s profile image [expired user #9130] posted 9 years ago Permalink
Hey,
thank you for the reply.
I tried the downgrade, sadly it doesnt work :(

but thanks for your help

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