Cyrillic ODBC problem

Gox · *nix forums beginner Joined: 24 Feb 2005 Posts: 2

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!

Google