MySQL Forums
Forum List  »  Connector/ODBC

Problems with Umlaute/UTF8 with MySQL Connector 8.0
Posted by: Frank Müller
Date: May 16, 2023 04:42AM

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"

Options: ReplyQuote


Subject
Written By
Posted
Problems with Umlaute/UTF8 with MySQL Connector 8.0
May 16, 2023 04:42AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.