Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mhd_sam
Starting Member
2 Posts |
 Posted - 2013-09-08 : 01:34:01
|
| Hello All,Hope you all are having great time.Just a small question for now. What should be data type of password field?Kindly get back to me if any thing require.Thanks in advance!!Regards,Sameer |
|
|
Mhd_sam
Starting Member
2 Posts |
Posted - 2013-09-08 : 01:35:58
|
| Just for more clarification:What should be data type of password field in sql? |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2013-09-08 : 05:07:15
|
You should never store a password in a table. Store the hash and compare the hash values.It is so much more secure.A hash value is typically a binary column. SHA-2 is BINARY(32).
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
|
|
|
|
What should be data type of password