• 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: talking to external MySQL servers
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: talking to external MySQL servers

  • Subject: Re: talking to external MySQL servers
  • From: <email@hidden>
  • Date: 19 Jun 2007 11:14:17 -0000
  • Bounce-to: <email@hidden>
MySQL Bridge should be expecting UTF8 encoded data (obviously, this is
not the case) that is why you have what could be described as a "bad
result" in your database.  How do you know for sure the encoding being
used for encoding a text, in fact you don't, so you'll have to let the
user precise the input encoding he is using (an trust him on this). Then
you want to insert those data in your database but then you also have to
take care of the encoding being used by MySQL and convert from the
encoding given by the user to the encoding used in MySQL, and IMHO text
encoding is pretty messy in MySQL DB but I could be wrong. If someone
wants to enlighten me on this, he would be more than welcomed, but I
guess this should be done privately and not on this list.

++ Jean-Baptiste

Le 19/6/2007, "Rainer Lau" <email@hidden> a écrit:

>This is one difference between MySQL Bridge and do shell script"mysql …"
>
>The Mysql DB uses COLLATION latin1_german2_ci
>
>MySQL Bridge should insert "Daß Übelgäbö" it writes in the DB "Da§
>†belgŠbš"
>
>do shell script"mysql …" should insert "Daß Übelgäbö" it writes in
>the DB "Daß Übelgäbö"
>
>Does MySQL DB support CONVERT(`astext`.`text` USING
>latin1_german2_ci) = 'Daß Übelgäbö'?
>
>
>--
>
>Rainer
>
>
>
>Am 19.06.2007 um 08:58 schrieb Jakob Peterhänsel:
>
>>
>> Ahh, ok.. nice.
>>
>> Maybe the developer could opensource the code, put it online
>> somewhere (like SourceForge) so it could get updated?
>>
>> Not that I'm any good with Xcode, but OS'ing it would be a start..
>>
>>
>>     Jakob Peterhänsel
>>
>> "Be a part of the Love Generation - carry a smile, not a gun."
>> - JP, May 2006
>>
>> Email:     email@hidden
>> AIM:         Marook
>> Phone:     +45 29687104
>>
>>
>> On 17/06/2007, at 22.36, Jean-Baptiste LE STANG wrote:
>>
>>> <http://lestang.org/osax/mysql/>
>>>
>>> MySQL Bridge is a faceless background application allowing someone
>>> to have access to SQL servers and lets you run queries against a
>>> database.
>>>
>>> ++ Jean-Baptiste
>>>
>>> On Jun 17, 2007, at 10:09 PM, Jakob Peterhänsel wrote:
>>>
>>>> Hi All,
>>>>
>>>> The MySQL wrapper I have, is "mySQL4AppleScript" from here:
>>>> http://www.yvs.eu.com/otherproducts.html
>>>>
>>>> It's no longer being maintained, and it's a AS wrapper for the
>>>> mysql client binary, so that needs a local mysql client installed.
>>>>
>>>>
>>>> But it's plain AppleScript to CLI, so it's just a matter of
>>>> updating it should it start to break.
>>>>
>>>> That 'MySQL Bridge', is that something else?
>>>>
>>>>
>>>>
>>>>     Jakob Peterhänsel
>>>>
>>>> "Be a part of the Love Generation - carry a smile, not a gun."
>>>> - JP, May 2006
>>>>
>>>> Email:     email@hidden
>>>> AIM:         Marook
>>>> Phone:     +45 29687104
>>>>
>>>>
>>>> On 15/06/2007, at 11.22, Håvard Graudo wrote:
>>>>
>>>>> AFAIK 'MySQL Brigde' is discontinued and unsupported. I was
>>>>> under the impression that it would not be updated.
>>>>>
>>>>> At some point it will probably break, and I am planning for that.
>>>>> Right now it is perfect!
>>>>>
>>>>> Håvard
>>>>>
>>>>>
>>>>>
>>>>> Den 15. jun. 2007 kl. 10.02 skrev <email@hidden>:
>>>>>
>>>>>>
>>>>>> I might be missing something but if MySQL Bridge is doing
>>>>>> everything
>>>>>> needed for you I do not really see what I can see more than
>>>>>> that :p
>>>>>> Yould you care to explain what you're missing ?
>>>>>>
>>>>>> TIA,
>>>>>>
>>>>>> Jean-Baptiste LE STANG
>>>>>>
>>>>>> Le 15/6/2007, "Håvard Graudo" <email@hidden> a écrit:
>>>>>>
>>>>>>> Rainer,
>>>>>>>
>>>>>>> I was unclear. I meant locally as in LAN. Distributing script +
>>>>>>> complete mysql to external clients is the showstopper.
>>>>>>>
>>>>>>> Mr Stangs "MySQL Bridge" is only 280k and does all that is
>>>>>>> needed. So
>>>>>>> replacing it with 40MB is .. well.
>>>>>>> But once installed mysql would be nice and fast.
>>>>>>>
>>>>>>> Håvard
>>>>>>>
>>>>>>>
>>>>>>> Den 14. jun. 2007 kl. 14.56 skrev Rainer Lau:
>>>>>>>
>>>>>>>> Yes, there are lots of ather and better ways, but
>>>>>>>>
>>>>>>>> mysql -h ( -- host)
>>>>>>>>
>>>>>>>> is not only locally.
>>>>>>>>
>>>>>>>> For me, it works fine. For each record in FileMaker I make a
>>>>>>>> record
>>>>>>>> on a LAMP (much more cheaper than FMS Advanced Pro an the
>>>>>>>> server is
>>>>>>>> outside the lan-firewall). To insert 1 record or update 1 to 20
>>>>>>>> records it is fast enough.
>>>>>>>> But if yo which to insert or update thousands of records, you
>>>>>>>> can
>>>>>>>> bild each mysql statement on this way.
>>>>>>>>
>>>>>>>> Here in a LAN, I make a mysql backup with mysqldump (50000
>>>>>>>> records)
>>>>>>>> - I can't see how it runs - it is to fast
>>>>>>>>
>>>>>>>> ; - )
>>>>>>>> --
>>>>>>>>
>>>>>>>> Rainer
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Am 14.06.2007 um 14:03 schrieb Håvard Graudo:
>>>>>>>>
>>>>>>>>> Thank you,
>>>>>>>>>
>>>>>>>>> This is doable locally …
>>>>>>>>>
>>>>>>>>> Den 14. jun. 2007 kl. 12.50 skrev Rainer Lau:
>>>>>>>>>
>>>>>>>>>> I use somethings like this
>>>>>>>>>>
>>>>>>>>>> do shell script "mysql -h 192.168.0.28
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> Do not post admin requests to the list. They will be ignored.
>>>>>>>> AppleScript-Users mailing list      (applescript-
>>>>>>>> email@hidden)
>>>>>>>> Help/Unsubscribe/Update your Subscription:
>>>>>>>> 40c2i.net
>>>>>>>> Archives: http://lists.apple.com/archives/applescript-users
>>>>>>>>
>>>>>>>> This email sent to email@hidden
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> Do not post admin requests to the list. They will be ignored.
>>>>>>> AppleScript-Users mailing list      (applescript-
>>>>>>> email@hidden)
>>>>>>> Help/Unsubscribe/Update your Subscription:
>>>>>>> 40lestang.org
>>>>>>> Archives: http://lists.apple.com/archives/applescript-users
>>>>>>>
>>>>>>> This email sent to email@hidden
>>>>>
>>>>> _______________________________________________
>>>>> Do not post admin requests to the list. They will be ignored.
>>>>> AppleScript-Users mailing list      (applescript-
>>>>> email@hidden)
>>>>> Help/Unsubscribe/Update your Subscription:
>>>>> 40hjemme.dk
>>>>> Archives: http://lists.apple.com/archives/applescript-users
>>>>>
>>>>> This email sent to email@hidden
>>>>
>>>> _______________________________________________
>>>> Do not post admin requests to the list. They will be ignored.
>>>> AppleScript-Users mailing list      (applescript-
>>>> email@hidden)
>>>> Help/Unsubscribe/Update your Subscription:
>>>> 40lestang.org
>>>> Archives: http://lists.apple.com/archives/applescript-users
>>>>
>>>> This email sent to email@hidden
>>>>
>>>
>>
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> AppleScript-Users mailing list      (applescript-
>> email@hidden)
>> Help/Unsubscribe/Update your Subscription:
>> email@hidden
>> Archives: http://lists.apple.com/archives/applescript-users
>>
>> This email sent to email@hidden
>
> _______________________________________________
>Do not post admin requests to the list. They will be ignored.
>AppleScript-Users mailing list      (email@hidden)
>Help/Unsubscribe/Update your Subscription:
>Archives: http://lists.apple.com/archives/applescript-users
>
>This email sent to email@hidden
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users

This email sent to email@hidden
  • Follow-Ups:
    • Re: talking to external MySQL servers
      • From: Philip Aker <email@hidden>
References: 
 >Re: talking to external MySQL servers (From: Rainer Lau <email@hidden>)

  • Prev by Date: Re: talking to external MySQL servers
  • Next by Date: Re: talking to external MySQL servers
  • Previous by thread: Re: talking to external MySQL servers
  • Next by thread: Re: talking to external MySQL servers
  • Index(es):
    • Date
    • Thread