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

Richard Huxton <dev@xxxxxxxxxxxx> · Fri, 10 Apr 2009 08:51:48 +0100

linnewbie wrote:
What I have on disk would be:

<p> Bonnie  &amp; Clyde</p>

which would usually be rendered as:

Bonnie & Clype

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

Bonnie &amp; Clyde

There are only three options.
1. That is *not* what you have stored in the database, it's being 
escaped on the way in.
2. You aren't displaying what *is* stored in the database, it's being 
escaped on the way out.
3. You are rendering it as text, not HTML

Break your problem into pieces and test each in turn. Store exactly that 
string and check it with psql. Examine exactly what you have when you 
read it from the database. Display two copies - one you have from the 
database and one you manually set in a variable. Do they differ?

--
  Richard Huxton
  Archonet Ltd

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