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, [EMAIL PROTECTED] 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.



_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to