Encoding problem on Mac with MySQL ODBC driver 8.0

I have an Excel file that is on a Google Drive. I use a Windows PC and my colleague uses a macOS 11 PC. We use Excel 365.

The file is connected to a Google MySQL database through ODBC MySQL Unicode driver 8.0. It's a MySQL table in French encoded in UTF-8 (with accent: à é ê è).

When they update the data the data is all messed up, but when I do it on Windows the data is fine.

For example, they get "FrÈdÈrique Brassard" but I get "Frédérique Brassard" which is correct. I would like to know if you know a way to fix this?