Hi there
env: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
I have a table where descriptions of certain items is saved. The French language description sometime contains letter with accent (for example, " réels "). The application GUI does not support inputting such characters (don't have the source code of the app - third party app). The only way to correct such issues is to execute UPDATE statement.
When I issue the following command and check in GUI, I notice that the French language character has been replaced with some weird characters as shown below (below the query):
update object_description
set object_desc = '..... réels ......'
where object_id = 123456789;
Output in GUI and TOAD:
.... réels ....
SQL*Plus shows the correct letter (é) though.
And when I issue this UPDATE from TOAD, I see correct letter in TOAD and in GUI but SQL*Plus shows the following:
.. r▒els ..
Any idea why is this happening? Here are some of the nls_database_parameters values:
NLS_LANGUAGE AMERICAN
NLS_CHARACTERSET WE8DEC
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 10.2.0.3.0
I have to update some descriptions and SQL script will be run via an application process which run it via SQL*Plus. The results from SQL*Plus update do not show the right character in GUI.
Please advise!
Regards