Paul,
I did try VARCHAR(16) BINARY and it still failed to INSERT in a NOT NULL
column.
The encrypted string seems to be equivalent to the NULL value even though
it visually looks like some kind of data.
Herb
> Please reply to the list, not to me directly, so that others can
> follow this discussion. Thanks.
>
> At 14:54 -0800 11/6/03, Herb Rubin wrote:
>>Paul,
>>
>>Yes, I get the same, now try and decrypt it, it will turn out to be
>>NULL. So, you cannot insert this into a NOT NULL column. It will reject
>>it.
>
> Your message (below) appears to be reporting a problem with
> AES_ENCRYPT(). It states that you get a NULL return value from that
> function.
>
> You now appear to be saying something else.
>
> I don't understand what problem you're trying to report.
>
>
> My result from decryption:
>
> mysql> select AES_ENCRYPT('551850040',
> '0bf251c9aaf007deaf1143ca1492b561');
> +--------------------------------------------------------------+
> | AES_ENCRYPT('551850040', '0bf251c9aaf007deaf1143ca1492b561') |
> +--------------------------------------------------------------+
> | k\��V���x��� |
> +--------------------------------------------------------------+
> 1 row in set (0.00 sec)
>
> mysql> select
> AES_DECRYPT(AES_ENCRYPT('551850040',
> '0bf251c9aaf007deaf1143ca1492b561'),
> -> '0bf251c9aaf007deaf1143ca1492b561');
> +-------------------------------------------------------------------------
--------------------------------------+
> | AES_DECRYPT(AES_ENCRYPT('551850040',
> '0bf251c9aaf007deaf1143ca1492b561'),
> '0bf251c9aaf007deaf1143ca1492b561') |
> +-------------------------------------------------------------------------
--------------------------------------+
> | 551850040
> |
> +-------------------------------------------------------------------------
--------------------------------------+
> 1 row in set (0.07 sec)
>
> Are you reporting that you get NULL only in the context of inserting
> and retrieving the value from the id column?
>
> If so, please try using TINYBLOB rather than VARCHAR and see what
> happens.
>
>
>>
>>we are on 4.0.14
>>Herb
>>
>>
>>> At 14:03 -0800 11/6/03, Herb Rubin wrote:
>>>>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
>
>
> --
> Paul DuBois, Senior Technical Writer
> Madison, Wisconsin, USA
> MySQL AB, www.mysql.com
>
> Are you MySQL certified? http://www.mysql.com/certification/
--
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]
