Has any one come across issues with AES_ENCRYPT function in MySql

[t_thakar]

Hi

Thank you in advance for the replies I will be getting.. Much appreciated.

Basically I am running the following mysql query using PDO

UPDATE users SET password = AES_ENCRYPT(:password,:supersalt)

Now the issue is..

on one computer I am getting ¶z8Ibﶘé®òŒd­Y in the password field but on another its blank. or sometimes

not sure what is causing the different results.

mysql version: 5.6.15
PHP: 5.6.16
Apache: 2.4.7

same versions on both PCs

Thanks

[ryantroop]

as noted here:
https://stackoverflow.com/questions/13713912/mysql-query-returns-blank-field-with-aes-encrypt

If it's not a blob type data field, you may get blank. If it contains invalid data, it may also return blank.

[t_thakar]

The issue I am having is that one computer its working and another computer its not .. so not sure what could be different..

fields on both computers are varchar(200) but works in one and not in other..

not sure if I need to set anything in mysql config file or any other config files such as Apache config or PHP config.

[AndrisP]

Convert to raw after encrypt and save as raw data in to the db.

[ryantroop]

when you say blank, do you mean null or an empty string?

Also, have you tried just running a hash by itself and seeing what the output is? (ie, select AES_ENCRYPT("string", "foo"); )

[ryantroop]

Also, since you're passing through PDO I assume you migrated machines or something like that - are you sure your PDO vars are being set correctly? If you pass in an err val for one of the parse vars, it's possible that would explain the empty value as well.