Facing issues with column names, with character ‘ñ’.

Hit to all,

We are in a 10.2.0.5.0 Oracle Database in a Linux box and facing issues with column names, with character  ‘ñ’.

Issue:

SQL> create table dummy (colñ char(1);

create table dummy (colñ char(1)

                      *

ERROR at line 1:

ORA-00911: invalid character

NLS_DATABASE PARAMETERS are:

SQL> select * from nls_database_parameters;

 

PARAMETER                     VALUE

------------------------------ ----------------------------------------

NLS_LANGUAGE                  AMERICAN

NLS_TERRITORY                 AMERICA

NLS_CURRENCY                  $

NLS_ISO_CURRENCY              AMERICA

NLS_NUMERIC_CHARACTERS        .,

NLS_CHARACTERSET              WE8MSWIN1252

NLS_CALENDAR                  GREGORIAN

NLS_DATE_FORMAT               DD-MON-RR

NLS_DATE_LANGUAGE             AMERICAN

NLS_SORT                      BINARY

NLS_TIME_FORMAT               HH.MI.SSXFF AM

NLS_TIMESTAMP_FORMAT          DD-MON-RR HH.MI.SSXFF AM