I am trying to insert some spanish chars from sqlplus to database.
NLS_CHARACTERSET=AL32UTF8
NLS_LANGUAGE=AMERICAN
NLS_TERRITORY=AMERICA
Unix:
echo $LANG
en_US.iso88591
SQLPLUS:
host echo $NLS_LANG
AMERICAN_AMERICA.WE8ISO8859P1
Insert into table1 (VALUE) Values ('Análisis'); //the spanish I pasted from some web page , didn't typed it manually as I don't have the layout
selecting this value returns some invalid characters (can't paste them as pasting also changes some chars).
select CONVERT(VALUE, 'WE8ISO8859P1', 'UTF8') from table1
return same corrupted characters.
Any ideas?