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 & 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
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 |