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 -> NLS functionality and replication between different character encoding schemes

NLS functionality and replication between different character encoding schemes

From: Melinda Schall <melinda.schall_at_daytonoh.ncr.com>
Date: 1997/11/11
Message-ID: <01bceeb2$49360e40$d7541995@aohemd4-schalm.DaytonOH.NCR.COM>#1/1

I am interested in hearing from anyone who has implemented or has knowledge of Oracle's nls functionality and its limitations relating to replication. Specifically,
I'm wondering if it's possible to replicate between two databases that are built with
different Character Encoding Schemes (for example: WE8ISO8859P1 -- West European and
JA16SJIS Japanese Shift-JIS).

Even if this proves impossible (which I'm guessing it is) I'm interested in hearing about
any solutions/ ideas regarding the global rollup of information from databases with different Character Encoding Schemes.

What I want to figure out is how best to allow users of the database in each country
to input most information in their own language; yet allow the sharing of some information
(with the shared information being in English) between users in other countries through the
use of replication.

Or even if someone could point me somewhere with more information on Oracle's NLS
functionality than the basic Oracle manuals provide. What I need more than anything
is a listing/explanation of the limitations of nls.

Also, I'm working in an Oracle 7.3.2 environment on NCR/UNIX. Thanks in advance for any help or discussion. Received on Tue Nov 11 1997 - 00:00:00 CST

Original text of this message

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