Encrypt files when downloaded as blob mysql

Hi Bala, There is no encoded value saved in the ini file in your sample code so the value decoded is not as you expected. If you want to encrypt the data, please use CrypterObject as Mike suggested.

Regards, Ken. Page : 1. There are no replies made for this question yet. However, you are not allowed to reply to this question. Please login to post a reply. Tuesday, November 14, PM. Raul, thanks for the solution on encrypting large amount of data. We have tried your approach on some BLOBs e. The performance is very dismal though it works. Downloading a 3MB file that's encrypted took more than 45 seconds the same file without encryption can be downloaded from the same webpage in 5 seconds. Any suggestions?

I understand that SQL Server is not an efficient way to store files to begin with but we have to use it due to data center restrictions. Tuesday, November 21, PM. Hey Bob, A lot of factors will impact the performance. Thanks, Sung. Wednesday, November 22, AM. Thanks again. Monday, November 27, PM. Tuesday, November 28, AM. Introducing Content Health, a new way to keep the knowledge base up-to-date. Podcast what if you could invest in your favorite developer?

Featured on Meta. Now live: A fully responsive profile. Reducing the weight of our footer. Linked Related Hot Network Questions. Question feed. Blob is the data type in MySQL that helps us store the object in the binary format. It is most typically used to store the files, images, etc media files for security reasons or some other purpose in MySQL. All these types differ in the storage space required and the maximum length that can e stored.

These datatype values are mostly treated as byte strings or binary strings. The BLOB values contain the binary character set and collation.

The bytes that are stored in such column values have numeric values based on which the sorting and comparison are done whenever performed in MySQL. The maximum row size of the table in MySQL is that represents the internal capability of the row even though the storage engine has larger capability support for rows. Along with the is for row buffer the BLOB valued data is stored in different areas of the memory and the allocation of the memory to this type of value differs for different storage engines.