Skip to Main Content

Oracle Database Discussions

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!

Cyrillic characters

Samuel RabiniMar 14 2011 — edited Mar 14 2011
Hi,
I'm working on an Oracle Database 11g Release 11.1.0.6.0 - 64bit Production With the Real Application Clusters option.

I need to use some cyrillic chars as column name in a file written from a PL/SQL block.
Using SQLDeveloper I can see right chars into package body:
    export_file := UTL_FILE.FOPEN('DIR_EXPORT','driving_profile_'||in_id_extraction||'_'||to_char(id_date_process,'yyyymmdd')||'.csv','W');
    UTL_FILE.PUT_LINE(export_file,
         'Дата;'||
         'Временной интервал;'||
         'Номерной знак;'||
         'VIN;'||
         'Код локации;'||
         'Пробег, км;'||
         'в т.ч. с превышением лимита скорости для данной территории;'||
         'Время в движении, часы;'||
         'в т.ч. с превышением лимита скорости для данной территории;'||
         'Средняя скорость, км/час;'||
         'Макс.скорость, км/час;'
               );
but the resulted file show this stuff:

Дата;Временной инÑ......

My client nls_lang is AMERICAN_AMERICA.AL32UTF8

The database server one is:
nls_language  AMERICAN

SQL> select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET';

VALUE
--------------------------------------------------------------------------------
AL32UTF8

SQL> select value from nls_database_parameters where parameter = 'NLS_NCHAR_CHARACTERSET'; 

VALUE
--------------------------------------------------------------------------------
AL16UTF16
I also tried to insert a string in a test table, and from SQL Developer I can see right chars:
insert into t_russo values ('Дата');

select * from t_russo;

TEXT                                                                                                                                                                                                                             
------------------
Дата     
But from SQL Plus from node1 I see this:
sqlplus dispatch/disp1

SQL*Plus: Release 11.1.0.6.0 - Production on Mon Mar 14 14:49:29 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
With the Real Application Clusters option

SQL> select * from t_russo;

TEXT
--------------------------------------------------------------------------------
????

SQL> quit                               
Does anyone suggest me something to achieve my goal?

Thanks in advance,
Samuel
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 11 2011
Added on Mar 14 2011
6 comments
2,917 views