Best way to store base64 data
I have a solution that grabs some base64 encoded pdf files from the web. About 20% of the records in the database will have this data, and it will not need to be viewed often. You guys think it would be better to keep it stored as base64encoded data in a text field and decode on the fly as needed, or decode it once and store the actual PDF in a container. The new base64encode and decode functions in FM 13 make the decoding of the data on the fly a very trivial task.