Re: NLS_CHARACTERSET ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 19 Apr 2001 16:48:10 +0200
Message-ID: <gjutdt44clhv7lr1rpvp4n0jel55bs8lnc_at_4ax.com>


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 - 16:48:10 CEST

Original text of this message