On Wed, Jan 30, 2002 at 04:18:07PM +0530, Nilanjan Das wrote: > Hi, > > Can anyone tell me how to use Placeholders when the datatype is > NVARCHAR2 or NACHAR and the database is Oracle. I always get the > following error. > > DBD::Oracle::st execute failed: ORA-12704: character set mismatch (DBD > ERROR: OCIStmtExecute) > > Can anyone of you help me? I tried many things but it is not working > anyway.
I've not done any worth with Oracle NCHAR/NVARCHAR2 types. I'd suggest changing the SQL to include an explict char set conversion function around the placeholder. Tim.
