TEXT Type Question

All:

I am converting sections of web pages to strings and storing them in a
MYSQL database. The field I use for storage has been defined with a
TEXT type and works fine for most entries with the exception of things
that look like this:

"Rants & Raves Readers on masked monopolies ... RIAA dorm-room
searches ... Maj. Gen. Monty Python ... and more.

Furthermore Smoking? What Smoking? In a voluntary, anonymous survey, 38
percent of cancer patients said they believe that cancer spreads
when exposed to air during surgery. The questionnaire was given to 626
patients at five urban clinics specializing in lung tumors and
diseases. "It may be surprising for some people to hear about this,
but it's not surprising to me or for many doctors who confront
patients with (cancer)," said Dr. Mitchell Margolis, the lead
researcher. Margolis said he decided to conduct the survey after
hearing the myth repeated by a "disconcerting number" of patients. Of
those who believed the myth, 24 percent said they would reject lung
cancer surgery based on that belief."

I get the following error message:

>>>DBD::mysql::db do failed: You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version for the
right syntax to use near 'It may be surprising for some people to hear
about this, but at My_module.pm line 292.

For the moment I'm assuming this has something to do with the quotation
marks beginning at "It may be surprising...".

Is that true?

If so, how might I deal with this?

If not, what else should I look for?

TIA,

Steve









--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org