Hi, what is the best suited datatype for storing data encrypted using AES_ENCRYPT and AES_DECRYPT?
It would be a blob.
Blob vs. VarBinary which one would perform better? I would like to add this field to an already existing database table that is read and written to quite often.
which db are you using?
I'm using MySQL 5.0.x (MyISAM)
if you know the length varbinary, otherwise blob