MySQL Forums
Forum List  »  Microsoft SQL Server

Urgent - Binary Column Types / Hashed Passwords
Posted by: brians_224
Date: June 08, 2005 07:47AM

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

Options: ReplyQuote


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.