using ü ö ä caracters in SQLPLUS
417598Mar 24 2004 — edited Mar 26 2004I did create a DATABASE with WE8ISO8859P15 so the German character are supported and there are correctly saved in the database but ....
1/ in SQLPLUS, when I do a "select table_name from all_tables" the table ACTIVITÄT for example in to see as ACTIVIT[]T (with [] a small square)
2/ in SQLPLUS, when i do a "select * from ACTIVITÄT" come the error :
ORA-00911: invalid character
note: I did set in my UNIX shell NLS_LANG=americna_america.WE8ISO8859P15