AW: I need help with UTF-8

[Tiemo Hollmann TB]

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-bounces at 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 at lists.runrev.com>
Cc: Tiemo Hollmann TB <toolbook at 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-bounces at 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 at lists.runrev.com>
Cc: Kay C Lan <lan.kc.macmail at 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 at 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 at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode