Re: UPPER(AES_DECRYPT(...)) bug?
pushkar <[email protected]> Wed, 13 Aug 2014 12:42:13 +0000 (UTC)
| Newsgroups | gmane.comp.php.database |
|---|---|
| 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`;
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php