Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> LANG and NLS_LANG for utf8
I am working on HP UNIX 11i and using Oracle9i. I already have set
NLS_LANG=AMERICAN_AMERICA.UTF8. My database instance is created wit
UTF8.
When I do export/import of database, do I also need to set LANG=C.utf8
or NLS_LANG is
good enough to preserve UTF8 characters which are non ASCII.
Despite both setting, have not been able to insert non ASCII utf8 characters using sqlloader. I inserted some non ASCII chacaters such Ö in a file on my PC, but when I copy and paste this to UNIX (even when LANG=C.utf8, somehow these charactres disappear).
Any help will be appreciated. Received on Wed Feb 15 2006 - 21:02:36 CST