Re: SQL - Encrypt fields

[Gqcy <gmufasa01@xxxxxxxxx>]

thanks...

that helped...

however...
MY STUPID MISTAKE...
I had "NOT NULL FOR BIT DATA"
on the wrong field.... not my password field...
when I fixed that, it worked great.





On 4/10/2014 4:25 PM, DeLong, Eric wrote:
> Right, as I recall, to do the decrypt, you must
>
> Set encryption password = 'testenc'
>
> Then use
>
> decrypt_char(ppswd)
>
> -Eric DeLong
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gqcy
> Sent: Thursday, April 10, 2014 4:05 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: SQL - Encrypt fields
>
> I have got the INSERT to work...
>
> insert into XXXXXX values(
> 'REDROCKS', 'gmagnuson',
> ENCRYPT_AES('brickbat15','testenc'),'test1','test2')
>
> 1 rows inserted...
>
> select decrypt_char(ppswd,'testenc') from XXXXXX
>
> column or global variable testenc not found
>
>
>
> how do I format my select to get my data back???????????