Update/insert/retrieve accented character in DB?
<p>I am using oracle 12G</p>

<p>when i run <code>@F:\update.sql</code> from sql plus it  displays accented character <code>é</code> as junk character when I retrieve from either sqlplus or sql developer</p>

<p>By when run the individual statement from sql plus. Now if I retrieve it from sqlplus, it displays the correct character, but when I retrieve it from sqldeveloper, it again displays the junk character.</p>

<p>update.sql content is this</p>

<pre><code>update employee set name ='é' where id= 1;
</code></pre>

<p>What i want is when i run @F:\update.sql , it should insert/update/retrieve it in correct format whether it is from sqlplus or any other tool ?</p>

<p>For information :- when i run </p>

<pre><code>   SELECT * FROM NLS_DATABASE_PARAMETERS  WHERE PARAMETER LIKE '%CHARACTERSET%' 
</code></pre>

<p>i get below information</p>

<pre><code>PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_CHARACTERSET               WE8MSWIN1252
NLS_NCHAR_CHARACTERSET         AL16UTF16
</code></pre>

<p>when i run <code>@.[%NLS_LANG%]</code> from command prompt i see</p>

<pre><code>SP2-0310: unable to open file ".[AMERICAN_AMERICA.WE8MSWIN1252]"
</code></pre>