Re: Wierd PHP/MySQL result

2009-09-22 Thread Mogens Melander
Yes, you are right. It's the json_encode that fail. It's strange though. The data that fail is "Humlebæk". Another query, in another form, returning "Værksted" don't fail in json_encode. echo $cust['oname'];give the correct value. On Tue, September 22, 2009 22:56, Mark Goodge wrote: > Mogen

Re: Wierd PHP/MySQL result

2009-09-22 Thread Mark Goodge
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) . "" . htmlspecialchars($sql,ENT_QU

Re: Wierd PHP/MySQL result (Solved)

2009-09-22 Thread Mogens Melander
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, Mog

Re: Wierd PHP/MySQL result

2009-09-22 Thread Mogens Melander
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) . "" . htmlspecialchars($sql,ENT_QUOTES) . "'}}"; } else {

query optimization question (my struggle against 'using temporary; using filesort')

2009-09-22 Thread Ciaran Lee
Hi, I hope this is the right place to ask a question about query optimization. Background: I have a database which has events, which occur in places (listings). Places have addresses, and addresses belong to a city. I can select the latest event within a particular city very efficiently (less tha

Wierd PHP/MySQL result

2009-09-22 Thread Mogens Melander
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:

SQL Error: 1205 - Lock exception with a tuned MySQL install

2009-09-22 Thread Grover Blue
I'm trying to get to the bottom of the 1205 exceptions I've been getting. I understand it's a lock, but I don't understand exactly why it's happening and how I can fix (either by recoding, table restructure, or mysql configuration). Also, I should note that I'm a Java developer using JPA, and not

Re: 100% CPU load problem

2009-09-22 Thread Lawrence Robertson
Is the status information correct? > mysql Ver 14.12 Distrib 5.0.27, for Win32 (ia32) Oh yes, I saw what happened. I was connecting to my server using a WinXP machine. But anyhow, I was told in the forums that maybe there are some duplicated server_id's connected to my master. I'm looking at i

Benetl, a free ETL tool for files using postgreSQL, is out in version 3.1 - update

2009-09-22 Thread benoît carpentier
Dear all, Benetl, a free ETL tool for files using postgreSQL (and now MySQL), is out in version 3.1. A small correction has been done to Benetl 3.1. This is now available online. You can freely download it at : www.benetl.net This new version brings the support of long as date. Benetl will a