Help using database & data conversion

Mark Schonewille m.schonewille at economy-x-talk.com
Tue Feb 16 17:00:53 EST 2016


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 tkuypers at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>




More information about the Use-livecode mailing list