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

On Apr 9, 1:00 pm, st...@blighty.com (Steve Atkins) wrote:
> 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 '&' is stored  I'm getting the 'raw'
> > '&'.
>
> > 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-gene...@postgresql.org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general

To clarify, I am not escaping the string in any way.

Say the page I am saving the database is the about us page form a
company website.
First, make a from to create the about us page in a  text area field,
then I copy the
html from my text editor and past it ino this text area from.  I then
have a cgi script which
takes the contents from the text area field and stores it in the
database.

What I have on disk would be:

................................
..............................
<p> Bonnie  & Clyde</p>

which would usually be rendered as:

Bonnie & Clype

but this is not happening, it's being rendered
as:

Bonnie & Clyde