| Lists: | pgsql-php |
|---|
| From: | Joe Nilson Zegarra Galvez <nzegarra(at)kolareal(dot)net> |
|---|---|
| To: | Lista PG-PHP <pgsql-php(at)postgresql(dot)org> |
| Subject: | field md5 |
| Date: | 2004-05-10 14:28:38 |
| Message-ID: | 1084199317.2679.3.camel@dune.kolareal.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-php |
Hi, i'm working with a table that must have the password field crypted
in md5 with php, i'm using a 7.3.4-RH Postgresql version, how i can set
the type of the field?, if the password must have 12 how max length but
is stored in md5?.
And is stable the 7.4.2? o r i must wait to the RHDB next release to
upgrade my postgres?.
Thankx 4 all
Regards
Joe Nilson
| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Joe Nilson Zegarra Galvez <nzegarra(at)kolareal(dot)net> |
| Cc: | Lista PG-PHP <pgsql-php(at)postgresql(dot)org> |
| Subject: | Re: field md5 |
| Date: | 2004-05-10 14:51:04 |
| Message-ID: | 409F96D8.30906@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-php |
> Hi, i'm working with a table that must have the password field crypted
> in md5 with php, i'm using a 7.3.4-RH Postgresql version, how i can set
> the type of the field?, if the password must have 12 how max length but
> is stored in md5?.
All MD5's are 32 characters in length. You need to have a field of type
VARCHAR(32) to store your encrypted password.
> And is stable the 7.4.2? o r i must wait to the RHDB next release to
> upgrade my postgres?.
7.4.2 is the latest, most stable release.
Chris
| From: | Benjamin Schulz <benjamin(at)schulz(dot)name> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Joe Nilson Zegarra Galvez <nzegarra(at)kolareal(dot)net>, Lista PG-PHP <pgsql-php(at)postgresql(dot)org> |
| Subject: | Re: field md5 |
| Date: | 2004-05-10 18:37:58 |
| Message-ID: | 1084214278.7293.0.camel@binsanity.itx |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-php |
> All MD5's are 32 characters in length. You need to have a field of type
> VARCHAR(32) to store your encrypted password.
char(32) would be the better choise i suppose
--
Benjamin Schulz
web: http://benjamin.schulz.name/
gpg: D1EBE448
| From: | Joolz <joolz(at)xs4all(dot)nl> |
|---|---|
| To: | Lista PG-PHP <pgsql-php(at)postgresql(dot)org> |
| Subject: | Re: field md5 |
| Date: | 2004-05-13 05:14:24 |
| Message-ID: | 20040513051424.GA2640@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-php |
> [Joe Nilson Zegarra Galvez schreef op 10-05-2004 09:28 -0500]
>
> Hi, i'm working with a table that must have the password field crypted
> in md5 with php, i'm using a 7.3.4-RH Postgresql version, how i can set
> the type of the field?, if the password must have 12 how max length but
> is stored in md5?.
FYI, I heard that 7.4 has a md5 function on board, so you wouldn't
have to depend on the php function. A better choice IMO. This way you
can change your interface to another script language and still have
the functionality.
As to the length: why not simply make it varchar and let pg handle the
storage? IIRC there is no difference between 2 filled varchar(10)
fields and 2 filled varchar fields.
> And is stable the 7.4.2? o r i must wait to the RHDB next release to
> upgrade my postgres?.
>
> Thankx 4 all
>
> Regards
>
>
> Joe Nilson
>
>
--
07:11-07:14
Fedora Core release 1 (Yarrow) Linux 2.4.22-1.2188.nptl