Hi all.

Here's my disclaimer: this question is solely MySQL-related - I just happen to be programming in PHP.


I have found some functionality which *appears* to be a bug, but I didn't want to report it before asking some intelligent people. I have this simple query:

SELECT UPPER('just a lower case string') AS `UPPER_STRING`, UPPER(AES_DECRYPT(AES_ENCRYPT('Bob Frapples', '1234ABCD'), '1234ABCD')) AS `UPPER_NAME`;

Expected result:

UPPER_STRING              UPPER_NAME
------------------------  ------------
JUST A LOWER CASE STRING  BOB FRAPPLES

Real result:

UPPER_STRING              UPPER_NAME
------------------------  ------------
JUST A LOWER CASE STRING  Bob Frapples


There is a similar bug report <http://bugs.mysql.com/bug.php?id=28072> that uses LCASE instead of UPPER. But, they have the same *lack of desired functionality*. MySQL people say it's not a bug due to how binary blah blah blah. Whatever - I don't buy that. It's not working *as it should*. On top of that, the docs for this encrypt stuff is quite minimal.

My questions to you: do you think this is a bug? And... is there an alternative to searching on fields that are encrypted using the LIKE operator?

Thanks,
~Philip


"Personally, most of my web applications do not have to factor 13.7 billion years of space drift in to the calculations, so PHP's rand function has been great for me..." ~S. Johnson

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to