On 25 Jan 2002 07:05:32 +0800, [EMAIL PROTECTED] (Steven Roussey)
wrote:
Does anyone have a best practices for efficiently storing md5 hash
values in MySQL?
--snip--
Md5 hash-- 16 bytes.
char(32) binary -- 32 bytes.
BIGINT -- 8 bytes
--snip--
Or you can use base64, which
Does anyone have a best practices for efficiently storing md5 hash
values in MySQL?
Since it is a 32 character string of hex numbers, I originally stored
them in a char(32) binary column. But that is wasted space (by a factor
of 2). And of course, these things add up, both in data files