Re: Help using database & data conversion
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-talk.com
https://www.facebook.com/marksch
Buy the most extensive book on the
LiveCode language:
http://livecodebeginner.economy-x-talk.com
Op 2/16/2016 om 21:28 schreef 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 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
Re: Help using database & data conversion
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 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
Help using database & data conversion
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
