So I'm new to MySQL and having a significant issue with importing CSV files with µ characters. I'm using version 8.0.29 and the default character set of MySql is utf8mb4 - utf8mb4_0900_ai_ci and MySQL Workbench 8.0.27.
I'm importing using workbench. The CSV files import fine when they do not contain the µ symbol but when I try to import a CSV file that does include µ I get the following error.
Unhandled exception: 'ascii' codec can't decode byte 0xc2 in position 64: ordinal not in range(128)
There are only five import encoding options available at this stage in the workbench and they are UTF8-8, UTF-16, latin1, latin2 and cp1250. None work and utf8mb4 is not an available option.
I can manually enter the µ symbol via workbench and this also successfully exports µ. The export file contains the µ symbol in text editor (Atom). If i try and import the same file exported I get the same error.
I have uninstalled MySQL and workbench several times to no avail. Any guidance would be appreciated. RM