On Mon, Sep 19, 2011 at 11:11 AM, Greg Sabino Mullane greg@endpoint.com wrote:
I'm also of the opinion that we should just store things as CHAR(32), unless someone thinks space is really at that much of a premium. The big advantage of 32 chars (i.e. 0-9a-f aka hexadecimal ) is that it's a standard way to represent things, making use of common tools (e.g. md5sum) much easier.
This is very sound advice. It also makes debugging much easier as things like PHPMyAdmin "just work", The math table's binary version was quite annoying to try to debug.
Conrad