| Re: problem encrypting data (AES_ENCRYPT/AES_DECRYPT) [message #181766 is a reply to message #181764] |
Thu, 30 May 2013 14:05   |
ViVi
Messages: 5
Registered: May 2013
Karma:
|
Junior Member |
|
|
> Vivi,
> Since your problem seems to be with the MySQL functions, you'll probably
> get better help in comp.databases.mysql, where the MySQL experts hang out..
You're right, it's a mysql problem.
Thank you for your help
Vivi
mysql> truncate table `ex_categoria_master` ;
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INTO `ex_categoria_master` (`categoria_nome`) VALUES
( AES_ENCRYPT('doppio apice " f','SALT') );
Query OK, 1 row affected, 1 warning (0.02 sec)
mysql> SELECT AES_DECRYPT(`categoria_nome`, 'SALT') as bunny ,
`categoria_nome` FROM `ex_categoria_master` where `categoria_idx` = 1;
+-------+--------------------------------+
| bunny | categoria_nome |
+-------+--------------------------------+
| NULL | gð]q’3$Û
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]