ORACLE to ACCESS character data mapping

Hello,

we try to insert data from ACCESS2.0 into an attached ORACLE 7.2 database via ODBC (ODBC fulfillment kit). It works fine, however there is a problem with character/text data:

Defining an ORACLE column with CHAR(2) and attaching it, results in a Text(2) column in ACC2.0. However, it is not possible to store more than 1 character into that column. Trying to store 2 chars is possible on the ACCESS side, but results in a total crash with an error message from ORACLE which indicates that the text string is not null terminated. It seems as if ORACLE needs a null terminated string, but the ODBC driver (or ACCESS?) does not add this one extra byte to the column length when retrieving table specs from ORACLE.

Is there any way 'round? Can I change the text size of attached tables/ columns in ACC? (B.t.w.: Any CHAR(x) results in (x-1) usable charachters).

Thanks for any help!

Christoph

Von/From    Christoph Geisse                  Forschungszentrum Juelich
Tel./Phone  (02461)61-2128                    ASS-BS
Mail        Ch.Geisse_at_kfa-juelich.de          D-52425 Juelich, GERMANY