Re: Help using database & data conversion

2016-02-16 Thread Mark Schonewille
Hi Ton, > When I use >put revDataFromQuery(,,dbID, vSQL) into vData > to retrieve the data from the mySQL database, vData contains binary > data Can you post the binary data? E.g. use urlEncode(vData) or put binaryDecode("h*",vData,x) put x Kind regards, Mark Schonewille

Re: Help using database & data conversion

2016-02-16 Thread Peter Haworth
What are the commands you are using to insert/update data in your mySQL database and your local SQLite database? Data needs to be textEncoded before the insertion/deletion and textDecoded when SELECTing. Also, not sure what you mean by "manually in the local database". Pete On Tue, Feb 16,

Help using database & data conversion

2016-02-16 Thread tkuyp...@telenet.be
After 2 nights I give up!!! Even though I can’t, I must fix this :-( I’m using LiveCode Community 7.1.2 (rc 1) on a Mac. I have a database setup in mySQL, from which I need to retrieve data and insert it into a local SQLite database. Both the online and local databases are setup the same, but