Доброго дня господа
Имею 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
Поля доступны но кирилицу КРОКОЗЯБРИТ
Помогите пожалуйста правильно подстроить