1. create a .fs file that uses the sqlexport command like the following
\cli sql
\change database northwind
select * from Orders
\sqlexport -f csv -o /Users/niels/Desktop/outpüt.csv
2. execute this fs file via runfluidscript-bundled.bat
3. The resulting filename of the export will be
outp�t.csv
see attached
This issue can only be reproduced if the .fs script is created using non-UTF8 encoding, e.g. using Cp1252 encoding.
The RunFluidScript commands provide two options for file encoding:
INPUT_ENCODING [-i] - [optional] Character encoding for the input file.
OUTPUT_ENCODING [-t] - [optional] Character encoding for the output file.
The default value for these two options is UTF-8. If the -i option is not specified, the .fs script will be read using UTF-8 encoding and therefore the file name in the sqlexport command won't be processed correctly.
In v14, the workaround is to specify the -i option when running RunFluidScript, e.g. -iCp1252. Note that "platform-default" is not a valid value for the -i and -t options of RunFluidScript.
In v15, fixed the RunFluidScript command to allow "platform-default" as a valid option for the -i and -t options. Uses can specify -iplatform-default when running RunFluidScript.
Issue #10983 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS 15.0.0-dev-49 |
No time estimate |
1 issue link |
is blocked by #10990
Issue #10990FluidShell commands default file encoding to UTF-8 |
This issue can only be reproduced if the .fs script is created using non-UTF8 encoding, e.g. using Cp1252 encoding.
The RunFluidScript commands provide two options for file encoding:
INPUT_ENCODING [-i] - [optional] Character encoding for the input file.
OUTPUT_ENCODING [-t] - [optional] Character encoding for the output file.
The default value for these two options is UTF-8. If the -i option is not specified, the .fs script will be read using UTF-8 encoding and therefore the file name in the sqlexport command won't be processed correctly.
In v14, the workaround is to specify the -i option when running RunFluidScript, e.g. -iCp1252. Note that "platform-default" is not a valid value for the -i and -t options of RunFluidScript.
In v15, fixed the RunFluidScript command to allow "platform-default" as a valid option for the -i and -t options. Uses can specify -iplatform-default when running RunFluidScript.