This discussion is archived
1 Reply Latest reply: May 21, 2012 5:11 AM by 927868 RSS

Running SQL*Plus with bash causes wrong encoding

921348 Newbie
Currently Being Moderated
I have a problem with running SQL*Plus in the bash. Here is my code

#!/bin/bash

#curl http://192.168.168.165:8080/api_test/xsql/f_exp_order_1016.xsql > script.sql
wget -O script.sql 192.168.168.165:8080/api_test/xsql/f_exp_order_1016.xsql
set NLS_LANG=_.UTF8
sqlplus /nolog << ENDL
connect login/password
set sqlblanklines on
start script.sql
exit
<<endl

I download the insert statements from our intranet, put it into sql file and run it through SQL*Plus. This is working fine. My problem is that when I save the file script.sql my encoding goes wrong. All special characters(like íášč) are broken and that's causing inserting wrong characters into my DB. Encoding of that file is UTF-8, also UTF-8 is set on the XSQL page on our intranet. So I really don't know where could be a problem.
And also any advices regarding to my script are welcomed, I am total newbie in Linux scripting:-)
Thanks a lot for answers

And also any advices regarding to my script are welcomed, I am total newbie in Linux scripting:-)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points