Charset problems passing foreign chars to PHP/MySQL from Mac

Mark Schonewille m.schonewille at economy-x-talk.com
Sat Sep 6 08:43:07 CDT 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
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 (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 "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.
>





More information about the use-livecode mailing list