LiveCode Forums.

Yes thanks!
..... but there is even a far more simple way, i read a bit on the stackoverflow site and tested it and the solution is very simple.

the whole database is UTF-8.

the script i used are edited in Notepad++, with coding as UTF8 (with BOM) , this BOM produces the characters you do not want to see.
So if you save the PHP scripts again with Notepad++ but then use coding UTF8 (without BOM) then the characters will not be shown in the livecode text fields.

So it simply has to do with the encoding of the scripts and the database, they have to match completely.

some usefull links:

http://en.wikipedia.org/wiki/Byte_order_mark#UTF-8
http://stackoverflow.com/questions/1505 ... 5#15051235
http://stackoverflow.com/questions/1446 ... ing-in-php
http://stackoverflow.com/questions/6779 ... characters
http://php.net/manual/en/mysqli.set-charset.php
http://stackoverflow.com/questions/2223 ... 41#6647241

Very interesting.

So you are working in Windows? I think that is a known bug. But you can fix that easily by installing Ubuntu.

Yes i'm working in Windows.
I tried that a few times, but i don't like Ubuntu. alltough it has some advantages.
It still feels not souplesse enough to me and above all that, my other hobby, making some music, and i tried it in Ubuntu, is totally nothing compared to windows or mac.
Total no support for vsti or from companies like Steinberg, Ableton etc etc etc i'm not going that adventure anymore.

If Commodore amiga had evolved like it should have then probably i would still be using that...ok this discussion is going to another direction.

But thanks for you suggestion.

I think this discussion was very helpful and should be made into a official livecode tutorial. Maybe one of the mods could do this?

istech wrote:I think this discussion was very helpful and should be made into a official livecode tutorial. Maybe one of the mods could do this?

The moderators here are volunteers and may not have the time to also summarize threads into tutorials. However, if you or any other member of the community wants to do that I'd happily flag it as "sticky" in this forum so others can find it easily.

I hear you Richard and agree. Time is always a factor in any voluntary role. Maybe a request can be made to RunRev to get a official tutorial done as this could help a lot of people looking to develop and join the live code ranks.

Presently I am still in the investigating level of this example. So would not be the best to write a extensive tutorial on this matter. But if that changes I will jump in feet legs and arms included.

Well there need to be some update as in the examples of the php scripts, direct mysql command will not be supported anymore as of 5.6 if i'm correct. So i was told on stackoverflow.com. So better is to learn PDO statements as this will be the future and/or use MYSQLi.

So for now this will work, but as soon your webhost updates his software it could be the case that it don't work anymore.

So i have to dive into that and in time change my script towards the new.
But for now it's working