Hmmm, my apologies all. I just retried the problem using the mysql command
line in place of the ODBC utility that I usually use and the string was
inserted just fine.
Thanks for the help
Dave
> -----Original Message-----
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 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
> > 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?
>
> Can you show us an example?
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
>
> MySQL 3.23.29: up 127 days, processed 788,109,342 queries (71/sec. avg)
>
---------------------------------------------------------------------
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
