JSON format

hi,

I created a function that returns an id field and proverb field in mysql.
Right now my function returns this row:

Code:

---

1"The die is cast"

---

In xml format this would probably look like this

Code:

---

<ID>1<\ID>
<Proverb>"The die is cast"<\Proverb>

---

I would like to know how would this row look like in JSON fomrat?

It would probably be:

Code:

---

{"ID": 1, "Proverb": "The die is cast"}

---

or if the double quotes are really part of the Proverb, then:

Code:

---

{"ID": 1, "Proverb": "\"The die is cast\""}

---

You should take a look at the syntax's description at json.org.

hm, i guess it is better that i remove double quotes in mysql database.