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 want obtain

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) mysql

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.

INSERT encrypted data

2006-01-18 Thread sharif islam
mysql insert into ccard values(AES_ENCRYPT(123453535,'uiwuerw'),'10/2003'); Query OK, 1 row affected (0.00 sec) mysql select * from ccard - ; +--+-+ | crypt| expire | +--+-+ | )\u\u\u\u\u\u\u |