Hi,

We have uploaded data into a table and ut had special characters in it ('éê*áèç'). Yet when I type out the following query I get :
SQL> l
1 select id, name
2* from cat where id = 10044680
SQL> /

ID
----------
NAME
--------------------------------------------
10044680
eeaaec

I also am pasting my db parameters when I type in a sho parameters: (I am only pasting the NLS specific ones):
nls_calendar string
nls_comp string
nls_currency string
nls_date_format string
nls_date_language string
nls_dual_currency string
nls_iso_currency string
nls_language string AMERICAN

NAME TYPE VALUE
------------------------------------ ------- ------------------------------
nls_numeric_characters string
nls_sort string
nls_territory string AMERICA
nls_time_format string
nls_time_tz_format string
nls_timestamp_format string
nls_timestamp_tz_format string


I am curious to know whether it gets stored correctly and is just displaying wrong..(how can I check this???)

Also if I can find a way to get new inserts correctly what happens to records already there?

Thanks,
Nirasha