This content has been marked as final. Show 3 replies
First I would need to repeat myself:
If you have My Oracle Support (MOS) access you may want to read the following documents.
[url https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=264157.1]The correct NLS_LANG setting in Unix Environments Doc ID 264157.1
[url https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=179133.1]The correct NLS_LANG in a Windows Environment Doc ID 179133.1,
Added in windows one because I dont know where you run your sqlplus...
If you run it in a *nix system.
- You connecting terminal uses UTF8 encoding (e.g. putty Window/Translation/Character set is UTF8)
- your console locale is UTF8 (see output of locale command, if not "en_US.UTF-8" use: export LC_ALL="en_US.UTF-8" if you can see utf8 available in "locale -a" available locales list)
- NLS_LANG set e.g. AMERICAN_AMERICA.AL32UTF8
- your input script is UTF8 encoded
if all these are setup well you should be good to go since your database can accept UTF8 characters.