Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> LANG and NLS_LANG for utf8

LANG and NLS_LANG for utf8

From: <dbaplusplus_at_hotmail.com>
Date: 15 Feb 2006 19:02:36 -0800
Message-ID: <1140057295.989912.140530@z14g2000cwz.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US