Problems with Umlaute/UTF8 with MySQL Connector 8.0

[Frank Müller]

Hi there, I'm pulling data from my Wordpress database (charset utf8mb4_unicode_ci) via MySQL Connector 8.0 into MS Access. This has worked well until I had to restore a backup on my website using Duplicator Backup Plugin. Now, all German Umlaute (ä, ü etc.) and other letters like ß are displayed incorrectly in Access (e.g. Ãœbersetzung instead of Übersetzung). I already installed the newest Connector version, I added CHARSET=utf8mb4 to my connection string (see below), nothing helped. Is there somthing else I can do? Thanks for help. Frank

Constr = "Driver=MySQL ODBC 8.0 Ansi Driver;" & _
"Server=" & server & "; User = " & user & ";Password = " & pw & ";Database=" & datenbank & "; CHARSET=utf8mb4"