I have a batch file that execute SQL scripts through sqlplus:
(
echo @"./myUTF8.sql"
echo @"./myAnsi.sql"
) | sqlplus uset/pwd@mybd
Unfortunately these SQL scripts are generated in different encoding, Ansi, UTF8, ...
How can I tell sqlplus that a script is of a specified encoding?
I have a SQL script created in UTF8, to run it with sqlplus in Linux, before open sqlplus do
export NLS_LANG=.AL32UTF8
then use sqlplus to load the script.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With