In Search of the Elusive Middleware Example
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Re: In Search of the Elusive Middleware Example
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
..... 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
-
- Livecode Opensource Backer
- Posts: 366
- Joined: Tue Apr 10, 2012 9:18 am
Re: In Search of the Elusive Middleware Example
Very interesting.
So you are working in Windows? I think that is a known bug. But you can fix that easily by installing Ubuntu.
So you are working in Windows? I think that is a known bug. But you can fix that easily by installing Ubuntu.
Re: In Search of the Elusive Middleware Example
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 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.
Re: In Search of the Elusive Middleware Example
I think this discussion was very helpful and should be made into a official livecode tutorial. Maybe one of the mods could do this?
-
- VIP Livecode Opensource Backer
- Posts: 9867
- Joined: Sat Apr 08, 2006 7:05 am
- Location: Los Angeles
- Contact:
Re: In Search of the Elusive Middleware Example
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 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?
Richard Gaskin
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn
Re: In Search of the Elusive Middleware Example
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.
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.
Re: In Search of the Elusive Middleware Example
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
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