| From: | truthhurts(at)insightbb(dot)com |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | MD5 Function |
| Date: | 2005-10-22 23:40:40 |
| Message-ID: | 102220052340.102.435ACDF8000519F70000006621979133639C05020E0D0E@insightbb.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi, I am trying to verify the return size that MD5 function returns. I dont see
any details mentioned about this in the docs.
Basically i am planning on storing passwords as md5(password) and want to know
if i can just declare the password field to be something like VARCHAR(32) or
even CHAR(32) if it's guaranteed that it will never be longer/shorter than 32
chars.
Perhaps this is not that big of a deal and i could as easily just declare it as
VARCHAR/TEXT without the size constraint. I just want to know what is best
storage and performance wise?
Thanks,
Aaron
| From | Date | Subject | |
|---|---|---|---|
| Next Message | me | 2005-10-23 01:04:13 | Re: WinXP Install - Account Password Information |
| Previous Message | operationsengineer1 | 2005-10-22 22:13:22 | Re: Excellent PGSQL Tutorial, WinXP as Service - Configure for Manual Operation |