INSERT unicode parameters error

From: vincent terrisse <vterrisse_at_infovista.fr>
Date: Thu, 02 Sep 1999 14:37:59 +0200
Message-ID: <37CE6FA7.EE14F25E@infovista.fr>

Working with myTable:
create table myTable( Name NVARCHAR2(127) not null)

I try to insert a new row with an ODBC application with two different methods:
-with a dynamic parameter:

INSERT INTO mytable (Name) VALUES (?)
I get "character set mismatch"

-with a hard coded parameter:

INSERT INTO mytable (Name) VALUES (N'toto') that's ok

What's wrong with the first method ??
ODBC driver = SQORA32.DLL(08.00.5600) on NT 4.0

thanks,
vincent Received on Thu Sep 02 1999 - 07:37:59 CDT