Re: [REQ] Applescript, do shell script e mysql
Re: [REQ] Applescript, do shell script e mysql
- Subject: Re: [REQ] Applescript, do shell script e mysql
- From: Christopher Nebel <email@hidden>
- Date: Thu, 3 Aug 2006 10:53:05 -0700
On Aug 3, 2006, at 5:27 AM, Marco Trotta wrote:
i'm trying to store some non-ascii text data in mysql using
mysql4applescript
this library uses "do shell script" in order to run mysql's command.
when i try to store character like this "è" in mysql became "Ã", the
"ù"
became "Ë" and so on.
I think is a charset problem. mysql's char_set_system is utf-8. Any
idea?
It certainly looks like an encoding mis-match, but I'm not sure
exactly what's going on. "do shell script" always transcodes the
script you give it into UTF-8, so if mysql is also set to use UTF-8,
then I'd think it would work, but obviously it doesn't. Go read <http://developer.apple.com/technotes/tn2002/tn2065.html
>, in particular the "non-ASCII text" question, and see if that sheds
any light on the matter. A few random guesses:
- Are there any other commands getting involved? One of them may be
the problem.
- Is the wrong value getting stored in the database? How do you
know? If you're getting the results back using "do shell script",
then the problem may be with the output from mysql, not the input.
--Chris Nebel
AppleScript Engineering
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden