Re: [GENERAL] storing binary data

2000-10-16 Thread Neil Conway
On Mon, Oct 16, 2000 at 11:22:40PM -0400, Tom Lane wrote: > Neil Conway <[EMAIL PROTECTED]> writes: > > 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

Re: [GENERAL] storing binary data

2000-10-16 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > 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? No. CHAR and friends assume there are

[GENERAL] storing binary data

2000-10-16 Thread Neil Conway
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 use