[JDBC] Unable to store SHA hash

2001-05-03 Thread Jerry Reid
I recently migrated an application from Oracle to Postgresql 7.1. The migration was fairly painless with one exception: User's passwords are hashed using SHA, then stored in the database. Ie. // Get the hash of the password MessageDigest md=null; try { md = MessageDigest.getIns

Re: [JDBC] Unable to store SHA hash (Non-HTML--Sorry)

2001-05-02 Thread Tom Lane
"Jerry Reid" <[EMAIL PROTECTED]> writes: > This string contains several characters that are outside the normal ASCII > range. The string could be stored and retrieved using Oracle and MySQL, but > in Postgres any unusual characters become '?'. Postgres will happily store anything except a null ('

[JDBC] Unable to store SHA hash (Non-HTML--Sorry)

2001-05-02 Thread Jerry Reid
I apologize if this message appears in duplicate. The original was posted before the I received notice that an additional confirmation message would be needed to get onto the list. I recently migrated an application from Oracle to Postgresql 7.1. The migration was fairly painless with one excep

[JDBC] Unable to store SHA hash

2001-05-02 Thread Jerry Reid
I apologize if this message appears in duplicate. The original was posted before the I received notice that an additional confirmation message would be needed to get onto the list.   I recently migrated an application from Oracle to Postgresql 7.1. Themigration was fairly painless with one exceptio