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

From: Steve Atkins <steve(at)blighty(dot)com>
To: pgsql-general List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Storing HTML: HTML entities being rendered in that raw form
Date: 2009-04-09 17:00:47
Message-ID: 2AC845F1-B6AA-43A2-B688-428101E941DA@blighty.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2009-04-09 17:02:48 Some suggestions for the non Linux installers
Previous Message Raymond O'Donnell 2009-04-09 16:59:35 Re: Storing HTML: HTML entities being rendered in that raw form