Re: [newbie] how do I force a numerical comparison of two md5 strings

[Michael T. Babcock]

Benjamin Pflugmann wrote:

So what's left is that you save the real md5 string instead of it's
hex representation, e.g. in a CHAR BINARY. That's easiest if you have
the binary representation on the client side. I see no easy way of
doing it in MySQL if you only have the hex rep (you could split it
into two strings and use CONV on each of it - but then you could go
and save them as two BIGINTs to begin with).

As Benjamin said later, I'm not sure its worth the performance difference, but you basically want for conversion is (pseudo-code because I can't be bothered to look up function names in your language of preference):

$md5bin = "";
for ($i = 0; $i < len($md5string)/2; $i+=2)
{
$md5bin += (char)(hex_to_int(mid($md5string, $i, 2))));
}

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php