Re: [fw-db] Mysql PDO: Selecting DES encrypted fields

Hello, it doesn't look to be related to Zend_Db, maybe this link will
help you.
http://bugs.mysql.com/bug.php?id=10589

dan k wrote:
> Hey,
> I have searched and have not found any discussion about this. I'm attempting
> to select fields that were encrypted with DES_ENCRYPT for example:
>
> $d = $db->fetchRow("SELECT
> DES_DECRYPT(street_address),city,state,zip_code,orderID FROM registration
> WHERE orderID=?", array($OrderID));
> print_r($d);
>
> Prints out:
>
> Array
> (
> [DES_DECRYPT(street_address)] =>
> [city] => TestCity
> [state] => IL
> [zip_code] => 12345
> [orderID] => 326829
> )
>
> So the unencrypted fields are returned correctly, but the DES_DECRYPT fields
> are always empty. Has anyone had any luck using DES encryption with Zend_DB?

--
Piotr Kabacinski
a2Fib3Q