char set still issues

hi sybrand,
[Quoted] i have a problem which looks similar or related to this one. pls advise.

here's my situation, we have a production database oracle 8.1.5.1 which runs [Quoted] a WE8ISO8859P1 nls_character_set -built database.

we have a development database which was built with a US7ASCII charset.

it seems to work okay from the apps, but lately exports and imports are internmittently
getting stuck, and apps seems to hang when ask to display 'imported' data. when new data
are created within the apps, it seems ok.

is there a genuine issue exporting and importing between databases of different
character set although the oracle dbms version and os are identical?

your help will be greatly appreciated.

any solutions.

tnx.

cathy gao
----- Original Message -----
From: "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> Newsgroups: comp.databases.oracle.tools
Sent: Thursday, April 19, 2001 10:48 AM
Subject: Re: NLS_CHARACTERSET ?

> On Thu, 19 Apr 2001 15:41:42 +0400, "Andrei V. Kirilenkov"
> <kirilenkov_at_sovintel.net> wrote:
>
> >I have created my DB with
> >NLS_CHARACTERSET = CL8ISO8859P5
> >NLS_NCHAR_CHARACTERSET = CL8ISO8859P5
> >which is ISO 8859-5 Latin/Cyrillic acoording to the documentation.
> >But after trying to insert the Russian string into a table I get only
> >'???????????????'
> >
> >Does anybody know what is wrong here?
> >
> >client nls_lang is AMERICAN_AMERICA.WE8ISO8859P1 (if matters at all)
> >
> Yes that matters at all. It is the very reason for your problem.
> Change the last bit after the . to CL8ISO8859P5
> and retry.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
Received on Thu Apr 19 2001 - 17:40:00 CEST