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 http://economy-x

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, 2