Mariadb: "mysql Ver 15.1 Distrib 10.3.8-MariaDB" OS: Windows 10 64 bit
I've been wrestling with getting a csv data file that contains "high 8 bit" characters such as the micron character and em dash read into a table in mariadb using "load data infile".
The database, tables and columns are all set to utf8.
After many attempts I got the file loaded in a clunky way by using an external program (Notepad++) to convert the csv file from the original ANSI Codepage 1252 (cp1252) encoding to utf8, and manually using "set names utf8" in the mysql client.
However i'm having trouble setting this up as the default config for the program.
From reading the Mariadb (Mdb) docs I set up my.cnf as-
# Set everything to utf8 (utfmb3 I believe?) [server] character_set_server = utf8 character_set_connection = utf8 default-collation = utf8_general_ci init-connect = 'SET NAMES utf8' [client] character_set_client = utf8 character_set_connection = utf8
but the mysql client chokes on the two client options with the errors-
mysql: unknown variable 'character_set_client=utf8' mysql: unknown variable 'character_set_connection=utf8'