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 -> Proper NLS settings for Multi-byte support

Proper NLS settings for Multi-byte support

From: William Jones <consultant_at_aawc.com>
Date: 15 Apr 2004 09:00:07 -0700
Message-ID: <f009ba4.0404150800.b5c3d25@posting.google.com>


Hello,

We currently have an Oracle 9.2.0.4 RAC database that will be handling mostly data in English; however, we need multi-byte support for future storage of text/address information from Japanese or Chinese sources.

Currently the NLS_CHARACTERSET value is set to WE8ISO8859P1 and the NLS_LANG on the server is AMERICAN_AMERICA.UTF8.

A little unclear as to the inter-relationship between NLS_LANG and NLS_CHARACTERSET; however, how can the above-mentioned database store multi-byte characters if NLS_CHARACTERSET is set to western European value?

 I have over seven years of solid Oracle DBA experience; however, new to internationalization (i.e., multi-byte support). Any enlightenment will be humbly appreciated. Especially, will the NLS_LANG and NLS_CHARACTERSET listed work for storing multibyte characters?

Regards,

William Received on Thu Apr 15 2004 - 11:00:07 CDT

Original text of this message

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