Hello,
I am migrating a LC 6 program to LC 8 and shortly before release, after I thought I have made all hurdles I am again lost with Mac - LC 8 - PHP - MySQL -UTF-8 and German Umlaute (the MySQL name field is "utf8_general_ci" coded): Scenario 1 (without local file): - Entering a name with Umlaute in LC: ok - Checking the name in LC: ok - Passing the name to PHP and writing it to a MySQL db: ok This works fine, without any changes in LC 6 and LC 8 Scenario 2 (with local file, without textencode): - Entering a name with Umlaute in LC: ok - Writing it to a local file - Reading it from a local file - Checking the name in LC: ok - Passing the name to PHP and writing it to a MySQL db: corrupted This works fine in LC 6 on Win and Mac. In LC 8 on Windows it is also ok, but running the program on MacOS 10.12, the Umlaute enter the MySQL database corrupted. Scenario 3 (textEncode before passing to PHP): - Entering a name with Umlaute in LC - Writing it to a local file - Reading it from a local file - textEncode() the content for the file: coruppted - Passing the name to PHP and writing it to a MySQL db: coruppted Scenario 4 (textEncode/Decode for local file and PHP): - Entering a name with Umlaute in LC - textEncode() the content for the file: coruppted - Writing it to a local file - Reading it from a local file - textDecode() the content from the file: corrupted - Alternativily additional: textEncode() the content from the file: corrupted - Passing the name to PHP and writing it to a MySQL db: coruppted It seems that I still havn't understood UTF-8 handling in LC Where is my fault? And why is it working on Windows and not on Mac? Thanks for any help! Tiemo _______________________________________________ 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
