NLS question

I had a quick question on the NLS configuration that I was hoping someone could help me out with

Oracle 11.2 database with NLS_CHARACTERSET=US7ASCII and NLS_NCHAR_CHARACTERSET=AL16UTF16

Developer creates a table with nvarchar2(1000) column and tries to insert a ó into that column.

Create table my_table(col1 nvarchar2(1000)); Insert into my_table values ('Acadó');

SQL> select * from my_table;
COL1

I was thinking this might be a session issue, but was not sure what I should have their client set NLS_LANG too. If I set NLS_LANG to AMERICAN_AMERICA.WE8MSWIN1252 in the session I get a different result, but not exactly the one I am looking for

SQL> select * from my_table;
COL1

Any help would be appreciated
Thanks in advance

--
http://www.freelists.org/webpage/oracle-l