can MS SQL store passwords encrypted like MySQL?
Moderator: General Moderators
can MS SQL store passwords encrypted like MySQL?
Or should I use php to do the encryption? If I use php, will the password be stored as the encrypted value or as the plain text?
-
bionicdonkey
- Forum Contributor
- Posts: 132
- Joined: Fri Jan 31, 2003 2:28 am
- Location: Sydney, Australia
- Contact:
you can encrypt the text in php before sending it to the db. e.g.
Code: Select all
<?php
$password = md5($password);
?>-
bionicdonkey
- Forum Contributor
- Posts: 132
- Joined: Fri Jan 31, 2003 2:28 am
- Location: Sydney, Australia
- Contact:
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
-
superwormy
- Forum Commoner
- Posts: 67
- Joined: Fri Oct 04, 2002 9:25 am
- Location: CT
- mydimension
- Moderator
- Posts: 531
- Joined: Tue Apr 23, 2002 6:00 pm
- Location: Lowell, MA USA
- Contact:
here is the rfc for the md5 algorithm: http://www.faqs.org/rfcs/rfc1321.html