ASP Oracle and UNICODE

From: Alessandro Rodilosso <a.rodilosso_at_esalab.it>
Date: 5 Jun 2001 01:15:39 -0700
Message-ID: <42760dfc.0106050015.285db23_at_posting.google.com>


Hi there,
I set an ASP application that interfaces with oracle dbms via stored procedures
I noticed that input parameters of stored procedures of VARCHAR2 type are translated by the oledb provider into unicode strings. The asp application runs on a NT4 server while the oracle 7.3.4 runs on a solaris 2.7 server machine.
So a string such as 'fred' is unsderstood by oracle as 'f r e d ' where the blanks are zero values.

I can't work around this problem . Can anyone give me a hint to have the correct translation?

Regards

Alessandro Received on Tue Jun 05 2001 - 10:15:39 CEST

Original text of this message