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
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
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.
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 |