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@home.com>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed
Secrecy is the beginning of tyranny.
-- Heinlein