Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Proper NLS settings for Multi-byte support
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