11 Replies Latest reply: Sep 12, 2013 9:11 AM by Eduardo Legatti RSS

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

    we*447480*79

      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