Hello,
when using the import wizard for accounts (with the downloaded comma separated file) the French characters are OK but the Swedish charaters are ok until step 4 of the import (the example of the right):
in the csv, the example in step 3 etc all is well however.
in the step 4 the first line example changes to:
Skånevägen becomes SkÃ¥nevägen
I have tried tons of settings (Mariadb 10.1.20 / apache 2.4) among which
changing default char set in config.php to latin1 and swe7
adapting several types of 8859 in the csv and in the import wizard step 3 under File Encoding: (View Import File Properties)
changing char set database to latin1 / utf-8
changing char set client and connection to respectively utf-8, swe7, latin1
French characters such as Hervé are fine.
Tx for your help
FYI: show variables like ‘char%’;
±-------------------------±---------------------------+
| Variable_name | Value |
±-------------------------±---------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/