Never mind. I got it working. I’m not exactly sure about the problem because the method I used should have been quite general. However, what made it work is that I had the contents of a list field in the array I was storing and that somehow caused an error when I tried to decode the array. I deleted that array key, because there was no reason I needed to have it in the db anyway, and it worked.
I’ll look into why and report back if I find anything interesting. Best, Bill > On May 21, 2017, at 5:23 PM, William Prothero via use-livecode > <use-livecode@lists.runrev.com> wrote: > > Whoops, I lied. > The data is stored incorrectly in the simulator too. > Hmm…. > The IDE stores it correctly. There is something in the encoding that I’m > missing. > Bill > >> On May 21, 2017, at 5:03 PM, William Prothero via use-livecode >> <use-livecode@lists.runrev.com> wrote: >> >> Folks: >> I have an app that stores data to a mysql database on my server. It works >> fine in the IDE and in the iPhone simulator. However, when I load the app >> onto the iPhone, the saved data is corrupted. >> >> I am saving an array. The array is saved in a big string that has been >> base64 encoded. >> >> When saving, I do: >> >> put arrayEncode(tArray) into tData >> >> put base64encode(tData) into xData >> >> put urlEncode(xData) into xData >> >> xData is sent to the db >> >> When I read back the data, I do the inverse: >> >> urlDecode >> base64Decode >> arrayDecode >> >> The base64 data on the db is different when I store it from the iPhone. I >> can see this with Navicat, which I use for db management. So, the problem is >> in the storing of the data. >> >> What the heck? I am just using a post command to a php script that writes to >> the db. >> >> Why would the iPhone data that is sent be different from that sent in the >> simulator? >> >> Mac OSX 10.12.4, Livecode 8.1.4 (rc2) and XCode 8.3. >> >> Any suggestions would be welcome. >> Thanks, >> Bill P. >> >> William A. Prothero >> http://earthlearningsolution.org/ >> >> _______________________________________________ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
