Re: Search engine doesn't work

On Sat, Jan 27, 2001 at 03:20:48PM +0100, Marc SCHAEFER wrote:
> I wanted to try in the archives how to store a md5sum best in a database
> (origin is 16 bytes binary, if I don't get a good answer I will use ASCII
> like the output of the md5sum UNIX command since this is easy to debug).

I'd say store it in base64 -- it should be 22 characters long, rather than
the 32 characters it would be if you used hexidecimal. You should also use
char(22), rather than varchar -- not that it matters much.

I don't know of a way to store the actual binary format, but that might
also be possible.

HTH,

Neil

--
Neil Conway <neilconway(at)home(dot)com>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed

Skepticism is the agent of truth.
-- Joseph Conrad