Cyrillic ODBC problem

From: Gox <goran.udovicic_at_vip.hr>
Date: Thu, 24 Feb 2005 22:18:58 +0100
Message-ID: <cvlgbs$5s4$1_at_ls219.htnet.hr>



Hi.

I have this situation:

Server: HP DL380 (LINUX)

Database:
PARAMETER VALUE


NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET EE8MSWIN1250
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 9.2.0.4.0

Client:
Win XP (Russian environment)
MS Office 2k (English)
OraClient: 9i (9.2.0.1)
NLS_LANG: RUSSIAN_CIS.CL8MSWIN1251
Oracle 9i ODBC driver (9.2.0.2)

My MS Access application (via Oracle ODBC driver) can't recongnize cyrillic char from database and I can't input and save any cyrillic char correctly.
Totally illegible.

When I used MS driver for Oracle, everything it's OK, but performance of this driver is many weaker then Oracle driver.

BTW. Other applications, such as TOAD, correctly display data on same client machine.

Please, give me some advice for problem solution.

Thank YOU for help! Received on Thu Feb 24 2005 - 22:18:58 CET

Original text of this message