MariaDB (Mysql) issue with encoding german characters

Discussion of open issues, suggestions and bugs regarding LinqConnect – Devart's LINQ to SQL compatible ORM
Post Reply
FlorianDahn
Posts: 26
Joined: Thu 06 Feb 2020 18:23

MariaDB (Mysql) issue with encoding german characters

Post by FlorianDahn » Fri 24 Jun 2022 14:53

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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: MariaDB (Mysql) issue with encoding german characters

Post by Shalex » Wed 05 Oct 2022 08:35

Please add "Unicode=true;" to your connection string. Refer to https://www.devart.com/dotconnect/mysql ... tring.html.

Post Reply