Re: ASP ORACLE and UNICODE

It sounds like you have a bad setting with respect to the character set. Probably on the local box (Win2k).

Look at your Windows environment variables for any NLS settings. Try issuing the SET command from command window as a rough check. However, it may be in the registry. If you have to, you can manually specify a character set.

In the registry, look for the NLS_LANG registry entry (there may be several). It should be blank, say NA, or have a single byte character set such as AMERICAN_AMERICA.WE8ISO8859P1.

*BEFORE* you change the registry, create a backup you can reload in case you accidentally corrupt it.

Good luck,
Chris Weiss

"Alessandro Rodilosso" <a.rodilosso_at_esalab.it> wrote in message news:42760dfc.0106080547.27bacef9_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 Fri Jun 08 2001 - 15:02:49 CDT