> 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
> 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
> 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.