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

From: Richard Huxton <dev(at)archonet(dot)com>
To: linnewbie <linnewbie(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Storing HTML: HTML entities being rendered in that raw form
Date: 2009-04-10 07:51:48
Message-ID: 49DEFA94.9040501@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marco Colombo 2009-04-10 09:00:59 Re: Storing HTML: HTML entities being rendered in that raw form
Previous Message Scott Marlowe 2009-04-10 02:27:02 Re: Postgres: Starting Server in background mode