Thanks for your reply.
I have read MYSQL documentation and they say:
The encryption and compression functions return binary strings. For many of these functions, the result might contain arbitrary byte values. If you want to store these results, use a BLOB column rather than a CHAR or VARCHAR column to avoid potential problems with trailing space removal that would change data values.
BLOB column will take unnecessary storage space in database, is there any other option to use CAHR or VARCHAR field to store the data.
