Page 1 of 1

MariaDB (Mysql) issue with encoding german characters

Posted: Fri 24 Jun 2022 14:53
by FlorianDahn
Hey!

I'm having some trouble accessing a wordpress database posts inside my blazor application.

When loading the Post_content im getting it but with a wrong encoding of german characters.
Looks like this:
Zur Einhaltung der Klimaziele m�ssen bis 2050 mehrere Millionen W�rmepumpen installiert werden!
The character id is 65533 .

Charset is utf8mb4 and collation is utf8mb4_0900_ai_ci

Not sure if I have to change the encoding somewhere.

Thank you
Warm regards
Florian Dahn

Re: MariaDB (Mysql) issue with encoding german characters

Posted: Wed 05 Oct 2022 08:35
by Shalex
Please add "Unicode=true;" to your connection string. Refer to https://www.devart.com/dotconnect/mysql ... tring.html.