Special characters
Posted: Fri Nov 15, 2019 4:44 pm
Hello Oleg,
I have an issue with exporting data into a csv-file using Oracle spooling via sqlplus.
I'm using a "Windows Server 2019 Standard, Version 1809, 64-bit" System and Robotask 7.6.2.988. A batch-file is connecting to the database and running a sql-file, which is spooling data out of the database into a csv-file.
The contents of the files are:
start.bat
exit | sqlplus "<schema>/<password>@<database>" @"spool.sql"
spool.sql
set heading off
set feedback off
set linesize 250
set trimspool on
set pagesize 0
spool "c:\temp\test\out.csv"
select 'title'
from dual;
select 'xäÄßx'
from dual;
spool off
Starting start.bat manually via file-explorer gives me this result inside file out.csv:
title
xäÄßx
This is good.
Starting start.bat via a single Robotask action ("run program/open document") without using any parameters gives me this result inside file out.csv:
title
xä-îx
This is bad.
I'm assuming, Robotask does nothing but starting start.bat and therefore I don't expect any difference.
So, what can I do, to get the "good" result even using Robotask?
Thanks in advance.
Best regards
I have an issue with exporting data into a csv-file using Oracle spooling via sqlplus.
I'm using a "Windows Server 2019 Standard, Version 1809, 64-bit" System and Robotask 7.6.2.988. A batch-file is connecting to the database and running a sql-file, which is spooling data out of the database into a csv-file.
The contents of the files are:
start.bat
exit | sqlplus "<schema>/<password>@<database>" @"spool.sql"
spool.sql
set heading off
set feedback off
set linesize 250
set trimspool on
set pagesize 0
spool "c:\temp\test\out.csv"
select 'title'
from dual;
select 'xäÄßx'
from dual;
spool off
Starting start.bat manually via file-explorer gives me this result inside file out.csv:
title
xäÄßx
This is good.
Starting start.bat via a single Robotask action ("run program/open document") without using any parameters gives me this result inside file out.csv:
title
xä-îx
This is bad.
I'm assuming, Robotask does nothing but starting start.bat and therefore I don't expect any difference.
So, what can I do, to get the "good" result even using Robotask?
Thanks in advance.
Best regards