Charset problems passing foreign chars to PHP/MySQL from Mac
m.schonewille at economy-x-talk.com
Sat Sep 6 08:43:07 CDT 2008
MacToIso seems right to me. Just make sure to use IsoToMac when your
database client runs on Mac.
Better might be UTF8.
Economy-x-Talk Consulting and Software Engineering
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 (running on my
> Mac), into a mySQL database:
> 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
> 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.
More information about the use-livecode