Access, Oracle and Special Characters

  • Thread starter Thread starter Arno Weiershaeuser
  • Start date Start date
A

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
 
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
 
Back
Top