Home:ALL Converter>Accents Oracle - special characters

Accents Oracle - special characters

Ask Time:2017-10-18T05:13:10         Author:Julian Puentes Uribe

Json Formatter

I'm changing a php server application from windows to Linux, when I query special characters from the Oracle database I always get ?. on the windows server I make this query

SQL> select length ('ñ') from dual;

LENGTH ('Ñ')
-----------
           1

and in linux it generates this

SQL> select length ('ñ') from dual;

LENGTH ('??')
------------
            2

Author:Julian Puentes Uribe,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/46799318/accents-oracle-special-characters
yy