Does the base64encode/decode functionality work with all content types that a container will store?
If not then what are the limitations?
I'm building sync functionality for an FM Go app that needs to run offline with the server
Nothing in the help to indicate that it does not work on certain types.
I don't think it does any attempt at trying to figure out what the binary is...
I read thru the help file and could find nothing that would indicate issues either.
Instead of testing every possible permutation I was hoping that this question would solicit any experiences with limitations.
There may not be limitation on file type, but file size.
I tried with a 5MB PDF, results no problem and takes about 5sec to insert file and encode.
600MB of .exe will takes about 600sec, but after several minutes FM crashed.
I used a calculation field (limited 1G chars by FM spec) to store encoded text, so the limit of container may be below 750MB.
The limit for a Container field is 4GB. I tested with a 95,834 KB word doc and encode / decode performed slow but worked. Perhaps you were bumping up against system ram limitations? Calc field result limits are by return type. Calc definitions are limited to 30,000 chars
Calc is short enough, only calling a function with a parameter of field name as Base64Encode ( container )
but I forgot that text field limit is decreased on FM13 as 10,000,000 chars, from 1 billion chars on FM12.
And, now I tested using a PDF 10,117,671 bytes, it is encoded on calculation field without problem.
The length is 13,845,234 (=10,117.671 / 57 * 78), what the matter this is >10,000,000.
Number field is stay "Up to 1 billion characters per field." in the document, so "<10million chars" seems not real limit.
Retrieving data ...