
Oracle OLE DB - Provider and ADO - Problem with Unicode
Hi!
I have the following Problem:
i want to update a record with the following statement:
Update User set sInformation = '€' where idUserID = 124
when i start the update statement in SQL - Plus it succeeds.
but when i start this statement via ADO and the Oracle OLE DB -
Provider
the Unicode Character is replaced by another character.
Does anyone know a solution?
I work with Oracle 8.1.7 database, and Oracle 8.1.7 OLE DB - Provider
and VB 6.0
This is my database connection string:
"Provider=OraOLEDB.Oracle.1;Persist Security
Info=False;UserID=user;Password=pwd;Data Source=db"
Ernesto