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 |
|
roshana
Starting Member
31 Posts |
 Posted - 2010-02-02 : 11:30:09
|
| Hi all,I have to create a password column in a table .But it should be a mixture of upper case,lower case characters ,numbers and special characters should i use binary collation for this column ?.If yes how to implement it?.Thanks in advanceroshana |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-02-02 : 12:06:02
|
| you shouldn't.You should hash the password and store the hash as a binary. Then in your app compare hashes instead of plain text passwords.You can use something like SHA-1 to hash the passwords.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
roshana
Starting Member
31 Posts |
Posted - 2010-02-02 : 12:17:53
|
| Thanks Charlie |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-02-02 : 12:23:06
|
| welcome.Check out the function HASHBYTES() for some more info. It can hash with many algorithms and there will be a similar function in whatever app environment you are using. SHA-1 is pretty easy to write if you don't have one.Best of luckCharlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
|
|
|
Password table collation