Гетерогенный сервис + КОДИРОВКА UTF8

HOME_X
Дата: 22.03.2011 12:27:30
Доброго дня господа

Имею ODBC подключение c кодировкой источника UFT8
(визуализирую данные средствами Windows - кирилица в порядке)

Имею параметры загрузки
HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\Key_OraDb10G_home1\NLS_LANG=RUSSIAN_CIS.UTF8

Имею параметры базы Oracle
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 
Connected as system
 
SQL> select * from v$version;
 
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE	10.2.0.1.0	Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

Имею настройку базы
select * from SYS.NLS_SESSION_PARAMETERS
union all
select * from SYS.NLS_DATABASE_PARAMETERS
union all
select * from SYS.NLS_INSTANCE_PARAMETERS

Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 
Connected as system

SQL> 
 
PARAMETER                                                                        VALUE
-------------------------------------------------------------------------------- --------------------------------------------------------------------------------
NLS_LANGUAGE                                                                     RUSSIAN
NLS_TERRITORY                                                                    CIS
NLS_CURRENCY                                                                     р.
NLS_ISO_CURRENCY                                                                 CIS
NLS_NUMERIC_CHARACTERS                                                           ,
NLS_CALENDAR                                                                     GREGORIAN
NLS_DATE_FORMAT                                                                  DD.MM.RR
NLS_DATE_LANGUAGE                                                                RUSSIAN
NLS_SORT                                                                         RUSSIAN
NLS_TIME_FORMAT                                                                  HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT                                                             DD.MM.RR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT                                                               HH24:MI:SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT                                                          DD.MM.RR HH24:MI:SSXFF TZR
NLS_DUAL_CURRENCY                                                                р.
NLS_COMP                                                                         BINARY
NLS_LENGTH_SEMANTICS                                                             BYTE
NLS_NCHAR_CONV_EXCP                                                              FALSE
NLS_LANGUAGE                                                                     AMERICAN
NLS_TERRITORY                                                                    AMERICA
NLS_CURRENCY                                                                     $
 
PARAMETER                                                                        VALUE
-------------------------------------------------------------------------------- --------------------------------------------------------------------------------
NLS_ISO_CURRENCY                                                                 AMERICA
NLS_NUMERIC_CHARACTERS                                                           .,
NLS_CHARACTERSET                                                                 UTF8
NLS_CALENDAR                                                                     GREGORIAN
NLS_DATE_FORMAT                                                                  DD-MON-RR
NLS_DATE_LANGUAGE                                                                AMERICAN
NLS_SORT                                                                         BINARY
NLS_TIME_FORMAT                                                                  HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT                                                             DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT                                                               HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT                                                          DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY                                                                $
NLS_COMP                                                                         BINARY
NLS_LENGTH_SEMANTICS                                                             BYTE
NLS_NCHAR_CONV_EXCP                                                              FALSE
NLS_NCHAR_CHARACTERSET                                                           UTF8
NLS_RDBMS_VERSION                                                                10.2.0.1.0
NLS_LANGUAGE                                                                     RUSSIAN
NLS_TERRITORY                                                                    RUSSIA
NLS_SORT                                                                         
NLS_DATE_LANGUAGE                                                                
 
PARAMETER                                                                        VALUE
-------------------------------------------------------------------------------- --------------------------------------------------------------------------------
NLS_DATE_FORMAT                                                                  
NLS_CURRENCY                                                                     
NLS_NUMERIC_CHARACTERS                                                           
NLS_ISO_CURRENCY                                                                 
NLS_CALENDAR                                                                     
NLS_TIME_FORMAT                                                                  
NLS_TIMESTAMP_FORMAT                                                             
NLS_TIME_TZ_FORMAT                                                               
NLS_TIMESTAMP_TZ_FORMAT                                                          
NLS_DUAL_CURRENCY                                                                
NLS_COMP                                                                         
NLS_LENGTH_SEMANTICS                                                             BYTE
NLS_NCHAR_CONV_EXCP                                                              FALSE
 
54 rows selected
 SQL> 


Имею настройку initODBC.ora
# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent. 

#
# HS init parameters
#

HS_FDS_CONNECT_INFO = TERBASE
HS_LANGUAGE = RUSSIAN_CIS.UTF8
HS_NLS_NCHAR = UTF8
HS_NLS_DATE_FORMAT = "YYYY-MM-DD HH24:MI:SS"
HS_FDS_TRACE_LEVEL = ON

#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>

Имею log выполнения запроса

Oracle Corporation --- ╨Т╨в╨Ю╨а╨Э╨Ш╨Ъ     ╨Ь╨Р╨а 22 2011 11:17:15.220
Heterogeneous Agent Release 
10.2.0.1.0 


(0) [Generic Connectivity Using ODBC] version: 4.6.1.0.0070
(0) connect string is: defTdpName=TERAS;SYNTAX=(ORACLE8_HOA, BASED_ON=ORACLE8,
(0) IDENTIFIER_QUOTE_CHAR="",
(0) CASE_SENSITIVE=CASE_SENSITIVE_QUOTE);BINDING=<navobj><binding><datasources><da-
(0) tasource name='TERAS' type='ODBC'
(0) connect='TERBASE'><driverProperties/></datasource></datasources><remoteMachine-
(0) s/><environment><optimizer noFlattener='true'/><misc year2000Policy='-1'
(0) consumerApi='1' sessionBehavior='4'/><queryProcessor parserDepth='2000'
(0) tokenSize='1000' noInsertParameterization='true'
 noThreadedReadAhead='true'
(0) noCommandReuse='true'/></environment></binding></navobj>
(0) ORACLE GENERIC GATEWAY Log File Started at 2011-03-22T11:17:15
(0) hoadtab(26); Entered.
(0) Table 1 - SAS_RR12
(0) Skipped field SC, unrecognized datatype.
(0) Skipped field MODEL, unrecognized datatype.
(0) Skipped field TYPE, unrecognized datatype.
(0) Skipped field DEPVAR, unrecognized datatype.
(0) hoapars(15); Entered.
(0) Sql Text is:
(0) SELECT A1."DAY",A1."RMSE",A1."INTERCEPT",A1."NM",A1."OT" FROM "SAS_RR12" A1
(0) hoapars(15); Entered.
(0) Sql Text is:
(0) SELECT A1."DAY",A1."RMSE",A1."INTERCEPT",A1."NM",A1."OT" FROM "SAS_RR12" A1

Игнорируеться ВСЕ текстовые поля данной кодировки
(0) Skipped field SC, unrecognized datatype.
(0) Skipped field MODEL, unrecognized datatype.
(0) Skipped field TYPE, unrecognized datatype.
(0) Skipped field DEPVAR, unrecognized datatype.


Если в ветке ODBC отключить
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\TERBASE\CharacterSet=UTF8
Поля доступны но кирилицу КРОКОЗЯБРИТ

Помогите пожалуйста правильно подстроить