Access, Oracle and Special Characters

[Arno Weiershaeuser]

Hello,

I have linked an an Oracle 9.2 table with Access 2000 via
ODBC. The tabel consists of two VARCHAR2 fields. Access
has problems to convert special characters (like the
German umlauts): Either they are converted to an upside
down question mark or a simple '#deleted' appears in the
corresponding dataset. Datasets without special characters
are handeled without problems. I can use MS-Query
to get and insert data from the same ODBC-Source without
problems. When I connect Access with Oracle 8.1.7, there
are also no problems.
Has anybody an idea?
Thanks,
Arno Weiershaeuser

 

[Arno Weiershaeuser]

Hi Bernd!
With the new ODBC driver, Access can convert special
characters. But is has problems with the length of the
fields: For example, I can only store five and not six
special characters within an varchar2(6) field. So I had
to increase the field's length. Thanks

Regards,
Arno Weiershaeuser