9 Replies Latest reply on Apr 13, 2012 10:37 AM by Nikolay Ivankin

    Spool Russian Characters from a unix(AIX) sql script

    HouseofHunger
      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