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
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
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
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
{
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
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:
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
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
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