Encoding/Charset - Umlaut in Query Result

Windows 11 with HeidiSQL 12.3.0.6589, Database: MariaDB or MySQL (TCP/IP)

Chars are displayed like:

charset/encoding ae = ä oe = ö ue = ü

on another Windows 11 with HeidiSQL 11.3.0.6295, same database, same connection

charset/encoding ae = ä oe = ö ue = ü

see attached image

any hints/ideas what to change? regional settings of winodws? Connection? can the encoding be changed somewhere? i'm stuck.

thanks, Christian

You're probably using the old libmysql.dll library in your session. Please try out libmariadb.dll.

Hi Ansgar

i just check both system -> File -> Session Manager -> on both the combobox is set to libmariadb.dll.

any other ideas?

appreciate your help!

/chris

Is it probably an outdated server version? If yes this is the same as reported in issue #1739, and you can solve it by preferring the older libmysql.dll.

Older (MySQL) servers mostly work better with the old libmysql.dll, while newer servers should be used with the newer libmariadb.dll.

update. i copied the HeidiSQL folder from %ProgramFiles% from the windows 11 system where the umlaut's are displayed correctly. That's version 11.3.0.6295 to the windows 11 system, where the umlaut's are not displayed correctly. now the umlaut's are displayed correctly on both systems. i'm using the same connection specification on both systems and on version 11 and version 12. as an additional test i copied the v12 to the other system and the error can be reproduced. so it's a v12 bug.

i'll keep using v11 then .. on both systems. if you want me to analyze it more deeply, feel free to give me instructions. you can also email me directory, no problem.

What about the server version?