Re: Oracle reports and russian language

From: Mark Malakanov <markmal_at_rogers.com>
Date: Tue, 02 Aug 2005 23:30:18 -0400
Message-ID: <tfydnfhs-oTUp23fRVn-tw@rogers.com>

Mark Malakanov wrote:

> I wanted to test it but failed to switch windows 2003 to understand 1251
> codepage :). It should be made via controlpanel, by setting a default
> language to Russian. I set. And I'm able to type in Russian but when it
> saves to file it saves ?????????. The same story with SQL*Plus. The oem
> console and windows eat russian chars. :(
>

It was actually a "feature" of SQLPlus (Bug 2858947). It can select russian, but it can't insert national chars when database codepage is different than national codepage. Plus is too smart. It translates from national to main codepage before passing to DB. :(
DB itself can accept and store Russian. for example data can be loaded using Loader.
So, it means that if russian data is stored in NVARCHAR all should be OK.

read also Note:227330.1 Character Sets & Conversion - Frequently Asked Questions #14. Received on Tue Aug 02 2005 - 22:30:18 CDT