Hi!

I have an Oracle 9.2 database set up with UTF-8 and
nls_length_semantics=char (W2000 Server). I have data in an access database
which I want to insert into oracle. I link from Access to Oracle using
Oracle ODBC driver version 9.02.00.54.

In Access I have a table with a text field with size 4 (Access is unicode
compatible so I can add 4 chinese characters if I want). In Oracle the field
is three times as big because the nls_length_semantics is char so the field
is varchar2(12) (4 char=12 bytes when using UTF-8). When I create a query to
insert data I get the following error

ORA-01461: can bind a LONG value only for insert into a LONG column.

I tried to set the "Force retrieval of Longs" on my ODBC driver (workarounds
tab) but I cannot get it to work.

Regards
/Hans

Hmm I seems to get it to work now when I enable "Force SQL_WChar support"
on the workarounds tab. I tested this earlier but it did not work then. When
I created a new odbc connection and enabled "Force SQL_WChar support" it
works. I'm not sure why I had to add a new ODBC datasource but maybe
connection pooling makes Access use the "pooled" values (so the new settings
do not apply)? I see now that the Force retrieval of Longs is only used when
fetching long columns.

Feel free to shed some light if you have any additional information about
this.

Regards
/Hans