Hi Mark,
as a simplified pseudo code it looks like this:
*put fld "name" into myName*
-- ...
*open file myFile for binary write*
*write myName to file myFile*
*close file myFile*
-- ...
*open file myFile for binary read*
*read from file myFile until EOF*
*close file myFile*
*put it into myName*
-- ...
*if the platform is "MacOS" then put macToISO(theName) into theName*
*put URL ("http://myUser:myPW@myURL"; & "mySQL.php?" & URLEncode(theName))
into rslt*
-- mySQL.php writes to a MySQL db, where theName column is encoded as
"utf8_general_ci"
-- ...
Without macToISO on a Mac client theName enters corrupted in the mySQL db
Tiemo
-----Ursprüngliche Nachricht-----
Von: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] Im Auftrag
von Mark Waddingham via use-livecode
Gesendet: Montag, 16. Januar 2017 14:45
An: How to use LiveCode <use-livecode@lists.runrev.com>
Cc: Mark Waddingham <m...@livecode.com>
Betreff: Re: Why do I still need MacToISO, when working with UTF-8?
Hi Tiemo,
On 2017-01-16 11:57, Tiemo Hollmann TB via use-livecode wrote:
> Now my German Umlaute don't get corrupted in the MySQL db and
> everything is fine, but I would like to understand the technical
> background. Why do I still need MacToISO() in LC 8 on a Mac and even
> worse, I didn't needed it in LC 6 in the same program. What am I
> missing here?
Can you explain (with code examples if possible) what you are calling
MacToIso() on, and how you are using its output?
It isn't entirely clear exactly what steps you are taking in your previous
email and it sounds like the problem is at the point of LC's communication
with PHP, rather than within LC.
Thanks in advance!
Mark.
--
Mark Waddingham ~ m...@livecode.com ~ http://www.livecode.com/
LiveCode: Everyone can create apps
_______________________________________________
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
