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