I am not very familiar with PHP, Drupal and drush but I inherited a site running on Windows Server 2019 (in the process of being migrated from Ubuntu). When I want to download some webforms using drush wfx, special characters like German "Umlaute" ä, ö and ü in the webform contents are not correctly displayed.
I am running Drupal 7.81 und using drush 7.0.0. I also tried to specifially set the encoding to UTF-8 in the config file drushrc.php (even though the description in the file says, it should not be necessary because drush will use UTF-8 anyway). In the browser, the characters in the webform show up correctly.
The database character set is utf8.
Any idea what to try and how to troubleshoot?
PS > Get-CimInstance -ClassName Win32_OperatingSystem | fl Caption,Version
Caption : Microsoft Windows Server 2019 Standard
Version : 10.0.17763
PS C:\xampp\mysql\bin> .\mysql.exe -uroot
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 7405
Server version: 10.1.38-MariaDB mariadb.org binary distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> SELECT @@character_set_database,@@collation_database;
+--------------------------+----------------------+
| @@character_set_database | @@collation_database |
+--------------------------+----------------------+
| latin1 | latin1_swedish_ci |
+--------------------------+----------------------+
1 row in set (0.00 sec)
MariaDB [(none)]> USE drupal;
Database changed
MariaDB [drupal]> SELECT @@character_set_database,@@collation_database;
+--------------------------+----------------------+
| @@character_set_database | @@collation_database |
+--------------------------+----------------------+
| utf8 | utf8_general_ci |
+--------------------------+----------------------+
1 row in set (0.00 sec)
PS C:\xampp\htdocs\onboarding> drush version
Drush Version : 7.0.0
PS C:\xampp\htdocs\onboarding> drush status
Drupal version : 7.81
Site URI : http://default
Database driver : mysql
Database hostname : localhost
Database port :
Database username : drupal
Database name : drupal
Drupal bootstrap : Successful
Drupal user :
Default theme : garland
Administration theme : seven
PHP executable : php.exe
PHP configuration : C:\drush\php\php.ini
PHP OS : WINNT
Drush script : C:\drush\vendor\drush\drush\drush.php
Drush version : 7.0.0
Drush temp directory : C:\Users\%USERNAME%\AppData\Local\Temp\13
Drush configuration : C:\ProgramData\drush\etc\drush\drushrc.php
Drush alias files :
Install profile : standard
Drupal root : C:\xampp\htdocs\onboarding
Site path : sites/default
File directory path : sites/default/files
Temporary file directory path : /tmp
