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, 2016 at 12:28 PM tkuyp...@telenet.be <tkuyp...@telenet.be> wrote: > 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 store UTF-8 > data > > In one of the fields in a mySQL database there is the word “bacteriën”. > > > When I use > put textDecode(revDataFromQuery(,,dbID, vSQL),"UTF8") into vData > to retrieve the data from the mySQL database, vData contains “bacterin" > > When I use > put textEncode(revDataFromQuery(,,dbID, vSQL),"UTF8") into vData > to retrieve the data from the mySQL database, vData contains “bacteriÎn" > > When I use > put revDataFromQuery(,,dbID, vSQL) into vData > to retrieve the data from the mySQL database, vData contains binary data > > When I enter the word “bacteriën” manually in the local database, I can > retrieve it without any problems, but I just can’t get it in there using > the regular database functions :-( > > Anyone? please? How do I get the correct data in my local database? > > > Met vriendelijke groeten, > Warm Regards, > > > > Ton Kuypers > +32 (0) 477 739 530 > > Steenweg op Leopoldsburg 100 • B-2490 • Balen • Belgium > www.publishingtools4u.com > > > > > > _______________________________________________ > 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
