Have you looked to see if magic_quotes are on? On Wed, Feb 24, 2010 at 1:03 PM, Jurian Sluiman <[email protected]> wrote: > On Sunday 21 Feb 2010 21:43:04 troels knak-nielsen wrote: >> If that's the case, then you have double escaping going on. The data >> should not contain the slash once it's in the database. The point of >> adding the slash is to "protect" the data when it's embedded in *the >> query*. That is also why you don't have to (and indeed should not) >> unescape anything when reading from the database. The slashes are >> *only* there because you're embedding data in a query. >> >> Compare this with a string literal in php. Given the following: >> >> echo "A \"double\" quote"; >> >> Running this php code will output: >> >> A "double" quote >> >> That's because the *data* doesn't contain any slashes. The slashes are >> there so that the php parser can read the literal string. Once they >> have been read into memory, the slashes are gone. Same thing with sql. > > (sorry for my late reaction) > > So actually it isn't the data *retrieval* but rather the *insertion* if I > understand you right? The things I do are 99% from the manual: > > * Database initialized by application resource (db params: host, username, > passwd, db name, isDefault = true) > * Data into model (My_Model_Name) and saves it into mapper > (My_Model_NameMapper). > * Mapper has DbTable obj, My_Model_DbTable_Name and extends > Zend_Db_Table_Abstract > * Data is saved through Zend_Db_Table_Abstract::insert() or > Zend_Db_Table_Abstract::update() methods > > After calling the method the strings are in the database like I said (so > _with_ quotes). What's are the things I can look after (php settings, mysql > settings, system settings) to solve this problem? > > Thanks in advance, > Jurian > -- > Jurian Sluiman > CTO Soflomo V.O.F. > http://soflomo.com >
-- ----------------------------------------- Mark Steudel P: 206.375.7244 [email protected] . : Work : . http://www.mindfulinteractive.com . : Play : . http://www.steudel.org/blog
