Re: Proper NLS settings for Multi-byte support

William;

If you haven't already, you'll find these PDFs very useful.

http://technet.oracle.com/products/oracle8i/listing.htm#nls

Alex Ivascu

"William Jones" <consultant_at_aawc.com> wrote in message news:f009ba4.0404150800.b5c3d25_at_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 - 13:14:37 CDT