I'm an avid user of q but have recently run into the following issue:
When I'm using q on Windows 11 within PowerShell 7.2.9, special characters like Ä, ä, Ö, ö, Ü, ü are not probably encoded in the output file.
Sample command in Windows Powershell:
q -W all "SELECT column1, column2, column3 from input.csv" --encoding=UTF-8 --query-encoding=UTF-8 --output-encoding=UTF-8 -d"," -H -O > output.csv
ä for example is turned into "├ñ".
When I'm executing the same command in Window's normal cmd, I see no encoding issues in the output file. I would however prefer to run it inside PowerShell as I can combine it with other powerful commands.
Hello!
I'm an avid user of q but have recently run into the following issue:
When I'm using q on Windows 11 within PowerShell 7.2.9, special characters like Ä, ä, Ö, ö, Ü, ü are not probably encoded in the output file.
Sample command in Windows Powershell:
q -W all "SELECT column1, column2, column3 from input.csv" --encoding=UTF-8 --query-encoding=UTF-8 --output-encoding=UTF-8 -d"," -H -O > output.csvä for example is turned into "├ñ".
When I'm executing the same command in Window's normal cmd, I see no encoding issues in the output file. I would however prefer to run it inside PowerShell as I can combine it with other powerful commands.
Do you know how to fix this?
Many thanks in advance.