Re: UPPER(AES_DECRYPT(...)) bug?
[email protected] (pushkar) Wed, 13 Aug 2014 12:42:13 +0000 (UTC)
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
Hi Philip Thompson,
You better use
SELECT UPPER('just a lower case string') AS `UPPER_STRING`,
UPPER(CONVERT(AES_DECRYPT(AES_ENCRYPT('Bob Frapples', '1234ABCD'),
'1234ABCD')USING latin1)) AS `UPPER_NAME`;