compressed text and mysql

I want to store compressed text using gzcompress into mysql field where fieldtype is text.

But i get error..
This error vanishes when i use plain text.

Error is to check manual.....

Question is how to store compressed data in mysql ?

Thank You.

what error message are you getting? Have you added slashes to the compressed value?

Error i get is

Quote:

---

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 'cUÓyM›û]YûßTS§mÖø_öè|®SÝT?½¥®Ê!y{ëVùÊP†’Â1�'‰;(§�è
h$1Cà�b

---

But when i use plain text (non-compressed) then there is no error at all and all things go fine.


Why to add slashes ?

I am just using gzcompress($string,9) and return value is tried to store.

Okay thank you john

addslashes function has solved the problem :)

Thanks for your help

John,visualAd,pengate :)

I don't even need to post anymore :p