• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: [REQ] Applescript, do shell script e mysql
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


  • Follow-Ups:
    • Re: [REQ] Applescript, do shell script e mysql
      • From: Marco Trotta <email@hidden>
References: 
 >[REQ] Applescript, do shell script e mysql (From: Marco Trotta <email@hidden>)

  • Prev by Date: Re: reconnect fetch using applescript
  • Next by Date: select text of document 1 in TextEdit?
  • Previous by thread: [REQ] Applescript, do shell script e mysql
  • Next by thread: Re: [REQ] Applescript, do shell script e mysql
  • Index(es):
    • Date
    • Thread