Re: INSERT encrypted data

2006-01-20 Thread Gleb Paharenko
Hello. What data type are you using to store the result of AES_DECRYPT? Please, send the CREATE statement for your table. sharif islam wrote: > On 1/19/06, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > >>Hello. >> >>What doesn't work? In case you want more help please, provide the >>results you wa

Re: INSERT encrypted data

2006-01-19 Thread sharif islam
On 1/19/06, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > Hello. > > What doesn't work? In case you want more help please, provide the > results you want obtain from your query and CREATE statement for you table. Sorry for not being clear. The data is getting saved as NULL instead of being encrypted

Re: INSERT encrypted data

2006-01-19 Thread Gleb Paharenko
Hello. What doesn't work? In case you want more help please, provide the results you want obtain from your query and CREATE statement for you table. sharif islam wrote: > mysql> insert into ccard values(AES_ENCRYPT(123453535,'uiwuerw'),'10/2003'); > Query OK, 1 row affected (0.00 sec) > > mysq