Re: Storing HTML: HTML entities being rendered in that raw form

Steve Atkins <steve@xxxxxxxxxxx> · Thu, 9 Apr 2009 10:00:47 -0700

On Apr 9, 2009, at 9:27 AM, linnewbie wrote:

Hi all,

I have stored HTML in a text field that I subsequently render on the
web.  However when I retrieve and render this data on the web I  am
getting the entities being rendered in their raw form, ie, instead of
getting the '&' symbol when '&amp;' is stored  I'm getting the 'raw'
'&amp;'.

I would be grateful if anyone can point out how I can get around this.

It's a problem in your code, not the database. You're probably
escaping it one time to many or unescaping it one time too few.

Cheers,
  Steve

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general