Re: LANG and NLS_LANG for UTF8

dbaplusplus_at_hotmail.com wrote:
> 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).

Your mistake is to set NLS_LANG to the database character set.

What is the output of 'locale' if typed on the command line from which you start the import/export?

You have to set NLS_LANG to the character set on the client side.

Usually that means that you should not set this variable at all. Try to unset NLS_LANG and see if things work out then.

Yours,
Laurenz Albe Received on Thu Feb 16 2006 - 01:48:15 CST