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. 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]