This discussion is archived
11 Replies Latest reply: Sep 12, 2013 7:11 AM by Eduardo Legatti RSS

How to Enter Special Characters With Run(@) Statement.

we*447480*79 Newbie
Currently Being Moderated

Hi

Oracle10g (R1)

NLS_CHARACTERSET='AL32UTF8'

 

When I insert record with special characters like 'hâta' with INSERT statement from client tool it works fine, But I execute the same INSERT statement from run statement i.e. "SQL>@/Dir_Name/Script_File_Name.sql" the special characters didn't inserted properly and it become some thing like 'h¿ta'.

How can I enter the special characters correctly from run (@) statement?

Thanks

Legend

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