thanks. that looks promising.
On Nov 24, 2009, at 11:11 AM, Robert Garcia wrote:
> I would agree using mysql, but I think you mean use aes_crypt()
> aes_decrypt(), or encode decode, there is no decrypt().
>
> So to insert a record
>
> insert into sometable ('name','somestringname') values
> ('namevalue',aes_crypt('somestringvalue','somekey'))
>
> Then to retrieve unencrypted:
>
> select name, aes_decrypt(somestringname,'somekey') as somestringname from
> sometable where name = 'smith'
>
> something like that.
>
> --
>
> Robert Garcia
> President - BigHead Technology
> VP Application Development - eventpix.com
> 13653 West Park Dr
> Magalia, Ca 95954
> ph: 530.645.4040 x222 fax: 530.645.4040
> [email protected] - [email protected]
> http://bighead.net/ - http://eventpix.com/
>
> On Nov 24, 2009, at 10:08 AM, John McGowan wrote:
>
>> Roland,
>>
>> Since you mentioned specifically mysql, don't forget that you can do your
>> encryption with a mysql function call. So you just need to do a custom
>> column or a direcdbms action.
>>
>> http://dev.mysql.com/doc/refman/5.1/en/encryption-functions.html
>>
>> you can call encrypt() when doing inserts or updates and call decrypt() when
>> doing selects
>>
>> There are other variations, so take a look at the link above and go from
>> there.
>>
>> --
>> /John
>> ________________________________________________________________________
>> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
>
> ________________________________________________________________________
> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
