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--
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 and
