We recently helped a client convert PDF files stored as a unicode string in a SQL Server binary column to actual PDF files, so that they can view the PDF files from within SQL Image Viewer.
Expanding on this idea, we could develop a product that helps users convert binary data from one form to another e.g.
- convert images from one format to another
- process images e.g. resize, add watermark etc
- compress blob data using zip or lz algorithms to reduce blob size
- link to external applications to process the blob data (e.g. ghostscript to compress PDF)
We would like to hear your thoughts to know if such an application would actually be useful to you. Please leave your comments below, thank you.
UTF8Tool is an application to encode files to the UTF-8 character set and vice-versa. You can download the application here. This application was originally created for a user who needed to decode/encode files stored in a text column in his database.
To use the application, select the option to either decode or encode the files. Then enter a search pattern in the Input folder option to locate your files. If we wanted to process only pdf files, we could enter something like this:
Next, enter the folder to store the processed files in, in the Output folder option e.g.
Once you’ve entered the values, click on the Start button to process your files. Note that any existing files in the output folder will be overwritten.