compressed text and mysql

[slice]

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.

[john tindell]

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

[slice]

Error i get is

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.

[slice]

Okay thank you john

addslashes function has solved the problem

Thanks for your help

John,visualAd,pengate

[penagate]

I don't even need to post anymore