Charset problems passing foreign chars to PHP/MySQL from Mac

Mark Schonewille m.schonewille at
Sat Sep 6 09:43:07 EDT 2008

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

Benefit from our inexpensive hosting services. See 
  for more info.

On 6 sep 2008, at 15:36, rgould8 at 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:
> 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 ""  
> 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.

More information about the Use-livecode mailing list