In Search of the Elusive Middleware Example

sphere · Post by **sphere** » Sun Apr 19, 2015 7:13 pm

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

ghettocottage · Post by **ghettocottage** » Sun Apr 19, 2015 7:35 pm

Very interesting.

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

sphere · Post by **sphere** » Sun Apr 19, 2015 9:47 pm

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.

istech · Post by **istech** » Fri May 22, 2015 8:14 am

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

FourthWorld · Post by **FourthWorld** » Fri May 22, 2015 3:28 pm

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.

istech · Post by **istech** » Mon Jun 15, 2015 2:58 pm

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.

sphere · Post by **sphere** » Mon Jun 15, 2015 3:56 pm

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

LiveCode Forums

In Search of the Elusive Middleware Example

Re: In Search of the Elusive Middleware Example

Re: In Search of the Elusive Middleware Example

Re: In Search of the Elusive Middleware Example

Re: In Search of the Elusive Middleware Example

Re: In Search of the Elusive Middleware Example

Re: In Search of the Elusive Middleware Example

Re: In Search of the Elusive Middleware Example