|
Title: JSON encode fails using blanks Post by: jaimi on September 10, 2012, 12:21:44 AM I have the following MySQL Query:
sql => SELECT ... , hom.hom_name AS HOM_NAME FROM ... where the value for hom_name is: hom_name => Nacromancer\'s Diamond after pushing the row to the rows array with array_push($rows, $row); I get the JSON output like this: jsonarr => {"total":"1","rows":[{"OLT40A002T_KEY":"10000042","OLT20A004T_KEY":"10000001","OLT20I001T_KEY":"10020043","PVA_NAME":"Grundausbildung","PVA_BEG_FORMAT":"01.01.2012","PVA_END_FORMAT":"31.12.2012","PNA_NAME":"Stawitzki, Jana","HOM_NAME":"Nacromancer\\'s"}]} The String is not complete, it omits the String after the blank. How can I deal with that? |