On Apr 9, 1:00 pm, st...@xxxxxxxxxxx (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...@xxxxxxxxxxxxxx) > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
