Problem when inserting data into UTF8 database using VB and ADO

From: Vesa Nopanen <nopanen_at_quartal.com>
Date: Mon, 4 Mar 2002 15:28:31 +0200
Message-ID: <a5vsq8$enc$1@news1.song.fi>

Hello!

I am unable to insert data into table which has NVARCHAR2 column using Visual Basic and ADO.
What happens is that I get a [Oracle][Ora]ORA-12704 character set mismatch error.

Database information:

NLS_RDBMS_VERSION                8.1.7.0.0
NLS_CHARACTERSET                   UTF8

NLS_NCHAR_CHARACTERSET UTF8 NLS_LANGUAGE FINNISH
NLS_TERRITORY FINLAND I have tried both client NLS_LANG settings: FINNISH_FINLAND.UTF8
FINNISH_FINLAND.WE8ISO8859P1
(The first database installation used WE8ISO8859P1 as CHARACTERSET and NCHAR_CHARACTERSET.) Oracle ODBC driver version is 8.01.75.00.

I have no problems when adding data using direct sql inserts if I identify national data with N'string' but this ADO behauvior is very alien to me.

Client application does the following:

A empty recordset is fetched into ADODB.Recordset (rsSave) variable. rsSave.AddNew
rsSave("Name").Value = strName ' Name is NVARCHAR2 column UpdateRS rsSave

During update I get the error message.

Thank you for any advice you may offer,
Vesa Nopanen
nopanen_at_quartal.com Received on Mon Mar 04 2002 - 07:28:31 CST