Charset problems passing foreign chars to PHP/MySQL from Mac
rgould8 at aol.com
rgould8 at aol.com
Sat Sep 6 10:20:45 EDT 2008
I've already tried MacToISO, but it doesn't convert "Rhône" to the right character-encoding:
put MactoISO("Rhône") returns "RhÙne"
whereas I need to convert "Rhône" to "Rh%C3%B4ne" in order to pass it to PHP/MySQL and get it to successfully save.
Is there something else I need to do in Revolution (in httpheaders perhaps?) to ensure that data gets passed in UTF8 format?
-----Original Message-----
From: Mark Schonewille <m.schonewille at economy-x-talk.com>
To: How to use Revolution <use-revolution at lists.runrev.com>
Sent: Sat, 6 Sep 2008 9:43 am
Subject: Re: Charset problems passing foreign chars to PHP/MySQL from Mac
Hi rgould8,
MacToIso seems right to me. Just make sure to use IsoToMac when your database client runs on Mac.
Better might be UTF8.
--
Best regards,
Mark Schonewille
Economy-x-Talk Consulting and Software Engineering
http://economy-x-talk.com
http://www.salery.biz
http://facebook.economy-x-talk.com
Benefit from our inexpensive hosting services. See http://economy-x-talk.com/server.html for more info.
On 6 sep 2008, at 15:36, rgould8 at aol.com wrote:
> I'm having trouble saving words with special characters into MySQL > from Revolution, and I'm sure I'm just missing something simple:
>
> (I hope these special characters come through in this email)
>
> Basically I need to pass this word from Revolution (run
ning on my > Mac), into a mySQL database:
>
> Rhône
>
> If I want to create an URL that I can use to pass Rhône to mySQL and > have it save properly, I use an URL like:
>
> put URL "http://www.myisp.com/updatadata.php?valuetopass=Rh%C3%B4ne" > into databack
>
> If I can get Rhône to convert to Rh%C3%B4ne I'm in business, > however, I've tried MactoISO, ISOtoMac, urlencode - - - everything I > can think of, but I can't seem to get the right conversion:
>
> put MactoISO("Rhône") returns "RhÙne"
>
> put urlencode("Rhône") returns "Rh%99ne"
>
> What is the secret formula to get to "Rhône" to convert to "Rh> %C3%B4ne"?
>
> What's REALLY annoying is that if I run my Rev app on a Windows box, > everything saves perfectly. It's just something to do with being on > the Mac platform. Not sure why.
>
_______________________________________________
use-revolution mailing list
use-revolution at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
More information about the use-livecode
mailing list