Hi there, in the past, I've used the MySQL Connector 5.1 driver to connect to my MySQL database. For several reasons, I now had to update to MySQL Connector 8.0. Unfortunately MySQL Connector 8.0 doesn't support my German Umlaute by default (ä, ü etc.). What I read about this is "The default character set has changed from latin1 to utf8mb4." which explains that I didn't have problems with 5.1. I tried adding Charset=Latin1 to my connection string, which didn't help however:
If I downgrade back to Driver 5.1., it works again. So the MySQL Connector must be the culprit. Is there another setting that I have to change in order to switch MySQL Connector 8.0 to latin1? Thanks for help.
Frank
Constr = "Driver=MySQL ODBC 8.0 Unicode Driver;" & _
"Server=" & server & ";User = " & user & ";Password = " & pw & ";Database=" & datenbank & ";CharSet=latin1;"
If I downgrade back to Driver 5.1., it works again. So the MySQL Connector must be the culprit. Is there another setting that I have to change in order to switch MySQL Connector 8.0 to latin1? Thanks for help.
Frank