| From: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
|---|---|
| To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | storing binary data |
| Date: | 2000-10-17 02:54:09 |
| Message-ID: | 20001016225409.A2992@klamath.dyndns.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I want to store some binary data in Postgres. The data is an
MD5 checksum of the user's password, in binary. It will be
exactly 16 bytes (since it is a one-way hash).
Can I store this safely in a CHAR column? Can the data be
treated normally (i.e. compare a binary checksum of the
password the user entered with the binary value stored
in the DB, etc).
Are there any issues I'll need to watch out for when
storing/manipulating binary data?
(I was going to RTFM and search the mailing list archives,
but they don't seem to be working.)
TIA,
Neil
--
Neil Conway <neilconway(at)home(dot)com>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed
Secrecy is the beginning of tyranny.
-- Heinlein
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-10-17 03:22:40 | Re: storing binary data |
| Previous Message | Rick Roberts | 2000-10-17 02:22:46 | Compiling JDBC Driver |