Urgent - Binary Column Types / Hashed Passwords
Thanks for your time.
I'm building an asp.net application using MySQL as the database. I've created a table to store usernames and passwords. During user creation and authentication - i'm presenting the db with a hashed password value.
When a hashed password is stored in a db - how should it appear in the table?
In the MySQL table I'm using to store username and passwords, it appears as
system.byte[]. The data type is defined as varchar(16), binary. The field is not behaving as it should during authentication - as long at I enter a valid username, the system authenticates me despite a correct or incorrect password value. I'm 100% confident in my code.
Can anyone help me to define the appropriate column type? My application works fine w/ with a MS SQL table but fails w/ MySql. In MS SQL the field is described as:[PWD] [binary] (16) NULL
Thanks again for your time!!!
Subject
Written By
Posted
Urgent - Binary Column Types / Hashed Passwords
June 08, 2005 07:47AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.