I think I found the solution by adding a macToISO() conversion to the string passing to the PHP. I have no idea, why this wasn't necessary in LC 6, probably I will never fully understand the LC UTF mechanism Thanks for caring Tiemo
-----Ursprüngliche Nachricht----- Von: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] Im Auftrag von Tiemo Hollmann TB via use-livecode Gesendet: Freitag, 13. Januar 2017 09:58 An: 'How to use LiveCode' <use-livecode@lists.runrev.com> Cc: Tiemo Hollmann TB <toolb...@kestner.de> Betreff: AW: I need help with UTF-8 Hi Kay C, I have checked the db data directly with phpMyAdmin and additionally with a LC Client connected to my db. Both show, that the Umlaute are correct, when having written it directly to the db from a LC field input, but are corrupted, when having written it first to a local file and then read it from the file and written it to the MySQL. The PHP and MySQL part was made by a third party and my knowledge is very limited to this part. I can see that the db field is coded in "utf8_general_ci" but in the PHP I don't find any differentiation between Windows and Mac. The db Client is my LC program. I am not aware of having set the LC program to any charset (though it is pretty old and complex). How could I set the client to a special charset? What syntax could I search for? Thank you Tiemo -----Ursprüngliche Nachricht----- Von: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] Im Auftrag von Kay C Lan via use-livecode Gesendet: Freitag, 13. Januar 2017 04:56 An: How to use LiveCode <use-livecode@lists.runrev.com> Cc: Kay C Lan <lan.kc.macm...@gmail.com> Betreff: Re: I need help with UTF-8 We may need to see your actual scripts to determine where the problem may be. Also, how do you know that your MySQL db data is corrupt? What program are you using to look at it? How was the db set up in the first place; what character set and collation? Is it possible that your Windows db Client is set to UTF8 whilst your Mac db Client is set to MacRoman? _______________________________________________ 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 _______________________________________________ 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
