oracle - SQL Developer Special Chars

Question

I am having problems with an Oracle Database and the ASCII char encoding.

I'm trying to make Update sentences on Varchar2() columns with strings that contains special characters like á, é, í, ó, ú, (spanish) etc.

Each time i recover the data from that column, as for example, instead of seeing 'ó', i got 'é??' or '髇'.

I'm writing Update sentences like:

UPDATE TABLE_1
SET DESCRIPTION = 'THIS IS A TEXT WITH SPECIAL CHAR ó éND'
WHERE ID = '1';

and when i do:

SELECT ID ||' | '|| DESCRIPTION FROM TABLE_1 WHERE ID = '1';'

I got:

1 | THIS IS A TEXT WITH SPECIAL CHAR 髇 END

I'm using SQL Developer Version 4.0.3

Thank you for the help.

Answer 1

You have to check the Nlslang in you registery and the database characterset, it seems they are different.

Example:

SELECT * FROM v$nls_parameters WHERE parameter LIKE 'NLS_CHARACTERSET'
/

PARAMETER                                                        VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
NLS_CHARACTERSET                                                 AL32UTF8

from the registery go to oracle registery and in nlslang add value American_America.Al32UTF8(as an example) similar what you have in the database.

By the way sometime also the issue its from the langauge in the control panel , if you want to use french characters is better to assign it french. (Control PanelClock, Language, and Region... then in administrative tab)