Re: Strange problem

Try a binary datatype for that column. RAW should work.

Vincent Yau <yauv_at_ohsu.edu> wrote in news:3F099D49.BDDAAE5E_at_ohsu.edu:

> Dear All:
>
> I have used MySQL as prototype on an application that I am developing.
> The project has been
> approved and I am now moving to Oracle for the production run. I have
a
> section
> that deals with user password. My front end is in JSP/Servlet using
> Apache tomcat and talking
> to Oracle 8i using JDBC driver from Oracle (but I am using the Oracle
9i
> driver).
> The user password, I am using MD5 hashes and storing the string copy of
> that hashes onto the database (as varchar).
> MySQL was ok. However, when I moved the application to talk to Oracle,
> I am always getting a different string back
> from the database than what I am saving into it. However, I am
> always getting back, from ORacle, the same
> set of characters. So it was consistently different but consistently
in
> the same format. So I think there
> are some character conversion that is happening. Some of the
> characters are non-printable characters so
> they look like rubbish. But you can still compare with your bare eyes
> as the strings always contain the
> same set of characters.
>
> I think I am missing something as to how Oracle handle non-printable
> character strings.
> Any help much appreciated!!
>
> Please email me as well as posting back to the newsgroup.
>
> Thanks
>
> --Vincent
> yauv_at_ohsu.edu
>
>
>
Received on Mon Jul 07 2003 - 12:56:11 CDT