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