Ok, i got it. It's the json_encode($cust) that seems to have problems with danish characters ( æ ø å Æ Ø Å ).
json_encode is supposed to work with utf8 only, and my tables are all utf8 so that's wierd too :( Seems like i get to do the json_encoding by hand. On Tue, September 22, 2009 22:35, Mogens Melander wrote: > Well, no typos. > > The relevant piece of code: > > if (! $cust = mysql_fetch_assoc($res)) > { > echo "{success: false, errors: { reason: 'Fetch Customer failed: " . > htmlspecialchars(mysql_error(),ENT_QUOTES) . > "<br>" . htmlspecialchars($sql,ENT_QUOTES) . "'}}"; > } > else > { > echo "{success: true, total: 1, results:[" . json_encode($cust) . "]}"; > } > > On Tue, September 22, 2009 22:11, lists-mysql wrote: >> You didn't show your php code, but I'd bet you have a typo, likely >> in assigning the returned value to the variable, or in the name of >> the variable you're printing. >> >> - Rick >> >> >> >> ------------ Original Message ------------ >>> Date: Tuesday, September 22, 2009 10:02:06 PM +0200 >>> From: Mogens Melander <mog...@fumlersoft.dk> >>> To: mysql@lists.mysql.com >>> Subject: Wierd PHP/MySQL result >>> >>> Hi guys >>> >>> I'm getting rather confused on this thing. >>> >>> Results returned from mysql console/query-browser is >>> different from what's returned from same query in PHP. >>> >>> Maybe someone smarter than me could shed some light on >>> what's going on. I'm clueless :( >>> >>> Environment is as follow: >>> >>> Mysql Server version: 5.1.22-rc-log Source distribution >>> PHP 5.2.9 (cli) (built: Mar 31 2009 18:41:50) >>> Apache/2.2.9 (Unix) mod_ssl/2.2.9 OpenSSL/0.9.8k DAV/2 PHP/5.2.9 >>> >>> The SQL: >>> >>> select c.id, c.owner, if(c.owner > 0, s.name, 'Unknown') oname >>> , c.fname, c.lname, c.addr1, c.addr2, c.zipcode, c.city >>> , c.phone, c.mobile, c.email, c.web, c.saldo >>> from customer c >>> left join shop s on s.id=c.owner >>> where c.id = 1; >>> >>> Result from PHP: >>> >>> "id":"1" >>> ,"owner":"2" >>> ,"oname":null <======= Problem data >>> ,"fname":"Jane" >>> ,"lname":"Doe" >>> ,"addr1":"Solvej 1" >>> ,"addr2":"" >>> ,"zipcode":"1234" >>> ,"city":"Sommerby" >>> ,"phone":"11 22 33 44" >>> ,"mobile":"" >>> ,"email":"" >>> ,"web":"" >>> ,"saldo":"-7500.00" >>> >>> Result from MySQL console/query-browser: >>> >>> 1 >>> , 2 >>> , 'Long description' <==== Correct data >>> , 'Jane' >>> , 'Doe' >>> , 'Solvej 1' >>> , '' >>> , '1234' >>> , 'Sommerby' >>> , '11 22 33 44' >>> , '' >>> , '' >>> , '' >>> , -7500.00 >>> > > > -- > Later > > Mogens Melander > > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mog...@fumlersoft.dk > -- Later Mogens Melander -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org