| From: | Sudheesh Krishnankutty <sudheesh(at)softjin(dot)com> |
|---|---|
| To: | pgsql <pgsql-novice(at)postgresql(dot)org> |
| Subject: | How to store encrypted data into database |
| Date: | 2002-10-09 05:30:01 |
| Message-ID: | 3DA3BED9.B5C69983@softjin.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi all,
I am creating a table that contains userid and encrypted password.
I am using SHA-1 algorithm for encrypting the plain text password.
I stored the encrypted password into tht postgres database as varchar.
While retrieving I found that all the characters are changed.
How should I store the encrypted password. My understanding is that
while storing as varchar the character encoding changes the encrypted
text.
I am I right?
So how to store the encrypted text.
regards
sudheesh
| Attachment | Content-Type | Size |
|---|---|---|
| sudheesh.vcf | text/x-vcard | 437 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thad Humphries | 2002-10-09 15:56:40 | date conversions |
| Previous Message | Josh Berkus | 2002-10-09 05:27:20 | Re: What causes a table's oid to change? |