database storing > as it's html equivalent

[Prisy]

While i save a record the database stores the character > as it's html
equivalent which is >. But when i update that record it saves the character
as > itself. Why would this happen?
--
Thanks
Prisy

[Nicholas Paldino [.NET/C# MVP]]

Prisy,

That doesn't sound like a database error, rather, it sounds like you are
getting in HTML encoding, and storing the record as that, not decoding the
string before you place it in the database.

Where are you getting the string from?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Prisy" <Pr***@discussions.microsoft.com> wrote in message
news:69**********************************@microsof t.com...

While i save a record the database stores the character > as it's html
equivalent which is >. But when i update that record it saves the
character
as > itself. Why would this happen?
--
Thanks
Prisy

[Prisy]

Hi Nicholas,

Thank you for your quick response. I figured out the answer to the problem.
The value is from a text area. Originally my code was as follows:

name = txtName.Value;

Instead either of the below will work:

name = txtName.InnerText;
or
name = Server.HtmlDecode(txtName.Value);

--
Thanks
Prisy
"Nicholas Paldino [.NET/C# MVP]" wrote:

Prisy,

That doesn't sound like a database error, rather, it sounds like you are
getting in HTML encoding, and storing the record as that, not decoding the
string before you place it in the database.

Where are you getting the string from?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Prisy" <Pr***@discussions.microsoft.com> wrote in message
news:69**********************************@microsof t.com...

While i save a record the database stores the character > as it's html
equivalent which is >. But when i update that record it saves the
character
as > itself. Why would this happen?
--
Thanks
Prisy