Prior to starting to check the iOS autorenewing purchases I have to prepare my server database. My real question is simple. I simply wanna understand what size I ought to result in the varchar area during my database.
I had been utilizing a varchar (4096) to keep my base64 encoded receipts.
But to tell the truth, I could not find anything regarding receipt length around the official documentation (or elsewhere). The only real factor Used to do find on Apple's docs could be that the receipt content/format is susceptible to change:
The contents and format from the store receipt is private and susceptible to change. The application shouldn't make an effort to parse the receipt data directly. Make use of the mechanism referred to here to validate the receipt and retrieve the data saved within it.
So most likely opting for text rather than varchar really is the greatest option.