1 Reply Latest reply: May 21, 2012 7:11 AM by 927868 RSS

    Running SQL*Plus with bash causes wrong encoding

    921348
      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:-)