Hi,
I am trying to use aes_encrypt and I get a NULL value with a specific string:
INSERT INTO test SET `id` = AES_ENCRYPT('551850040', '0bf251c9aaf007deaf1143ca1492b561');
my field 'id' is VARCHAR(16) NOT NULL
If I change the value or the encryption string it works. But this combination turns out to be null and it refuses to insert.
With MySQL 4.0.14, 4.0.16, and 4.1.1, I get:
mysql> select AES_ENCRYPT('551850040', '0bf251c9aaf007deaf1143ca1492b561'); +--------------------------------------------------------------+ | AES_ENCRYPT('551850040', '0bf251c9aaf007deaf1143ca1492b561') | +--------------------------------------------------------------+ | k\ÎúVÀàÿxû÷Ò | +--------------------------------------------------------------+
What version are you using?
Help!
Herb
-- Herb Rubin www.pfinders.com Pathfinders Software phone: 650-692-9220 [EMAIL PROTECTED] fax: 650-692-9250
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]