Oracle Database Discussions

Hi,

we have several problems with an ODBC Connection from Lotus Notes 6.5 to Oracle database 10GR2 (Oracle Client 10.2 and ODBC Driver 10.02.00.03). I suppose these are Lotus Notes problems, but maybe somebody has an idea.

1) We cannot update a row in a table whether a column is declared as 'varchar2( 10 char)'. Surprisingly, the declaration of 'varchar2(10)', which represents 'varchar(10 bytes)', can be updated. We know that notes is not able to determine the 'native data type' 'varchar' in the first case.

2) We cannot update or delete a row with a varchar2 value with trailing blanks. Ok we can use trim in every update or within a trigger, but this cannot be the right solution.

Are there any odbc configurations / settings to prevent such behavior e.g. to cut trailing blanks.
Are there other experiences with this strange constellation (Lotus Notes + Relational database)

Thanks

André