BLOB Field and Quotes Problem

[Michael42]

Hello,

I have a mySQL 4 database with a text\blob field type being accessed via a php <textarea> tag. This <textarea> is used to handle memo type entries. I think I have narrowed my problem down to...quotes(' &quot;). Single and double.

If I have a memo entry with no quotes my updates work. If I have multiple embedded quotes my updates do not work. It would be a monstrous task to remove the quotes from the data and greatly decrease usability if I did so.

Works:
UPDATE articles SET Category='Access',Title='Expand Memo or Text Box',Memo='Shift-F2' WHERE id=823

No Work:
UPDATE articles SET Category='Access',Title='Expand Memo or Text Box',Memo='Shift-F2'' WHERE id=823

How would you recommend handling memo type files with single and double quotes?

P.S. The data was imported from Access and the field in question was a memo type.


Thanks,

Michael42

 

[RISTMO]

Try this:

UPDATE articles SET Category='Access',Title='Expand Memo or Text Box',Memo='Shift-F2\'' WHERE id=823

Rick

-----------------------------------------------------------

http://www.ristmo.com/

RISTMO Designs

http://www.arabchurch.com/

Arab Church

 

[Michael42]

RISTMO,

Thanks for the reply. My example is a microcosm of my data. Some of my BLOB fields may have 2-5k of comments that contain single and double quotes.

Would simply adding a forward slash to the begining or end address this (Memo=\Bla ba&quot; bla bla's. More bla bla's\ )?

Thanks for your help,

Michael42