Re: Storing HTML: HTML entities being rendered in that raw form - Mailing list pgsql-general

From Richard Huxton
Subject Re: Storing HTML: HTML entities being rendered in that raw form
Date
Msg-id 49DEFA94.9040501@archonet.com
Whole thread Raw
In response to Re: Storing HTML: HTML entities being rendered in that raw form  (linnewbie <linnewbie@gmail.com>)
List pgsql-general
linnewbie wrote:
> 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

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

pgsql-general by date:

Previous
From: Kevin Field
Date:
Subject: Re: indirect membership in group roles
Next
From: Marco Colombo
Date:
Subject: Re: Storing HTML: HTML entities being rendered in that raw form