Replace the single single quote character with two single quote characters.
Your example: INSERT INTO row (ref,text) VALUES ('1','This is,'some text
that', will probably mess things up')
would be: INSERT INTO row (ref,text) VALUES ('1','This is,''some text
that'', will probably mess things up')
George Mayne
*********** REPLY SEPARATOR ***********
On 1/3/02 at 1:08 PM Chris Denman wrote:
>Hi Group,
>
>I have been using Perl DBD::CSV for a project. The main reason for this
is
>because I can tweak the csv files very easily, speeding up project
>development. I will use something like mySql when finished.
>
>My question is:
>
>I get problems with the single quote character. Double quotes are fine,
and
>seem to be handled automatically by the system.
>
>e.g. INSERT INTO row (ref,text) VALUES ('1','This is,'some text that',
will
>probably mess things up')
>
>Any ideas?
>
>Thanks
>
>Chris Denman
