Re: Proper NLS settings for Multi-byte support

William,

I too am under the same constraints, and our VP has a trip planned to China to meet potential customers/resellers!!

What I do know is, you will not be able to store dual-byte characters into a database that has a "native" language of WE8ISO8859P1 unless you will store such data exclusively in columns of type NCHAR, NVARCHAR2 or NCLOB.

db

"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 - 14:20:09 CDT