Good question/observation - I am using a main stream language - an almost-homemade
which does have a "replace" functionality which allows me to replave a ' with \' - on a
per field basis - as i have which dozens of fields to attend to, and would have to code
this for each field.
Which is a bit clunky.
Anything I can do at the server end? Version 5.0.45.
>Yes, there are plenty of smart ways to deal with this. Each of them
>is somewhat dependant on whatever general purpose programming language
>you are using and/or the environment you are working in.
>In PHP we have mysql_escape_string() or PDO, in perl and Java, among
>others, prepared statements are generally used. python appears to use
>prepared statements under the covers.. it provides an similar
>facility, at any rate.
>What are you working in?
>- michael dykman
>On Fri, Oct 30, 2009 at 12:06 PM, Sydney Puente <sydneypuente@stripped> wrote:
>> I am populating mysql with data, from an external source, that now and again in
>> different fields has single quotes within the data intended to be inserted into
>> This causes a sql parse error.
>> Is there are smart way of dealing with this?