double encoded html code

Question

I use xinha as WYSIWYG editor for html-content. I sent html-articles via post-form to postgresql. So far so good, they seem ok. But when I receive and output from pg to an html page, I see double encoded, i.e. broken html code like this

&lt;p&gt;&lt;a href=&quot;http://google.com&quot;&gt;google.com&lt;/a&gt;&lt;/p&gt;   &lt;p&gt; &lt;/p&gt;   &lt;p&gt;

Any idea on where to search for the issue? Thanks in advance

You should probably post some code to explain how you're getting the data in and out of postgres. — Colin Dunklau, Jun 01 '12 at 23:44
How about a more specific breakdown of the process? You're not providing a whole lot to go on. — Joel Cornett, Jun 01 '12 at 23:44
Seems similar to [this question](http://stackoverflow.com/questions/275174/how-do-i-perform-html-decoding-encoding-using-python-django) — Junuxx, Jun 02 '12 at 02:21

score 2 · Answer 1 · answered Jun 02 '12 at 05:20

import HTMLParser
hp=HTMLParser.HTMLParser()
s="&lt;p&gt;&lt;a href=&quot;http://google.com&quot;&gt;google.com&lt;/a&gt;&lt;/p&gt;   &lt;p&gt; &lt;/p&gt;   &lt;p&gt;"
print hp.unescape(s)

# u'<p><a href="http://google.com">google.com</a></p>   <p> </p>   <p>'

double encoded html code

1 Answers1