That SQL statement provided should work just fine without any escape
sequences (at least as far as MySQL is concerned). The semicolons (;)
should be treated as part of a literal string, and therefore, inserted
into the image_data table.
Perhaps you're running this script from some utility or som
sday, May 10, 2001 5:31 PM
> To: Dave Emerson
> Cc: [EMAIL PROTECTED]
> Subject: Re: escaping semicolon in strings
>
>
> On Thu, May 10, 2001 at 05:16:42PM -0400, Dave Emerson wrote:
>
> > I'm trying to store strings the database that contain html character
> >
ODBC]
> -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 ex
On Thu, May 10, 2001 at 05:16:42PM -0400, 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 wor
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
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?
