Help using database & data conversion

Peter Haworth pete at lcsql.com
Tue Feb 16 16:55:43 EST 2016


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 tkuypers at telenet.be <tkuypers at 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 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