how to store password as encryted

Hi,
to store encrypted password in your database use VARCHAR field. Only make sure that the size of your field is enough for encrypted passwords.

If you have table with usernames and passwords you can encrypt existent passwords with following script:

http://www.xlinesoft.com/articles/encrypt_passwords.htm