I'm doing an insert via a SQL script:
insert into image_data (title)
values ("“Blue Clearwing” (Dulcedo polita)");
The error returned is:
Error: (-1) You have an error in your SQL syntax near '"$#147' at line 1
State:42000,Native:1064,Origin:[TCX][MyODBC]
> -----Original Message-----
> From: j.urban [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 10, 2001 5:28 PM
> To: Dave Emerson
> Cc: [EMAIL PROTECTED]
> Subject: Re: escaping semicolon in strings
>
>
> How are you inserting the strings (ie C, Perl, etc)?
> What is the exact string you're tying to insert?
> What is the exact error message returned?
>
>
> On Thu, 10 May 2001, Dave Emerson wrote:
>
> > I'm trying to store strings the database that contain html
> > character entities in them.
> > It appears that the insert fails when it sees the semicolon that
> > terminates
> > the entity. I've tried escaping it with \ but that doesn't
> work. What's
> > the proper way to escape a semicolon embedded in a string?
> >
> > Thanks,
> > Dave.
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
