Oracle ODAC 11 and OLE DB Provider Unicode Issue
Hi
first of all, I'm not sure, I hit the right community. Maybe somebody can move this to the right place.
My issue is about ODAC / OLE DB provider. I didn't find an entry that.
I did some tests with lastest ODAC and stumpled upon an unicode problem:
Insert or Update on nvarchar field does not work, results are some rotated question marks in the changed field.
Display of data put to DB with other connectivity is ok.
Some details:
I'm using ADO OLE DB Provider of latest ODAC (which has errors I guess),
field is nvarchar2(100),
connected to 10 g database using AL16UTF16 for 'N' Field types, but created with charset WE8ISO8859P1
first of all, I'm not sure, I hit the right community. Maybe somebody can move this to the right place.
My issue is about ODAC / OLE DB provider. I didn't find an entry that.
I did some tests with lastest ODAC and stumpled upon an unicode problem:
Insert or Update on nvarchar field does not work, results are some rotated question marks in the changed field.
Display of data put to DB with other connectivity is ok.
Some details:
I'm using ADO OLE DB Provider of latest ODAC (which has errors I guess),
field is nvarchar2(100),
connected to 10 g database using AL16UTF16 for 'N' Field types, but created with charset WE8ISO8859P1
0