Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Spool Russian Characters from a unix(AIX) sql script

HouseofHungerApr 12 2012 — edited Apr 13 2012

Hi All,

I have a problem selecting and spooling a column whose characters are in russian to a flat file. If I use oracle sql developer, the data comes out right, e.g

Р-Н ТАШКЕНТ

However is i try to run the same select from a unix sql script and spool the results, I get some gibberish like:
ò-î ôáûëåîô or a chain of question marks ?????????

select * from nls_database_parameters gives:
NLS_LANGUAGE=AMERICAN
NLS_TERRITORY=AMERICA
NLS_CHARACTERSET=UTF8
NLS_NCHAR_CHARACTERSET=AL16UTF16

I have tried exporting the environment variable using these various options individially to no avail:
export NLS_LANG=RUSSIAN_CIS.CL8MSWIN1251
RUSSIAN_RUSSIA.RU8PC866
RUSSIAN_RUSSIA.CL8KOI8R
RUSSIAN_RUSSIA.CL8MACCYRILLICS
RUSSIAN_RUSSIA.RU8PC855
RUSSIAN_RUSSIA.RU8BESTA
RUSSIAN_RUSSIA.CL8ISO8859P5

Please help.

Thanks,

Edited by: HouseofHunger on Apr 12, 2012 4:02 PM

This post has been answered by Nikolay Ivankin on Apr 13 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 11 2012

Added on Apr 12 2012

#database-key-features, #globalization-support

9 comments

1,529 views