Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-12-20 : 08:00:05
|
| James writes "We enter the following HTML into a textarea: & £ € – … ‘ ’ “ ” We then press submit to save the text into the database via a stored procedure When the HTML comes back it has been converted by SQL Server and instead of giving us back the HTML it give us the translated HTML in the text area:& £ é € - … ‘ ’ “ ” The field where we are storing this is a text data type. Why does SQL server do this as we require the HTML text not the translated HTML?" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-12-20 : 08:16:54
|
emm... so you want to display HTML syntax on your page??i don't quite understand your problem...Go with the flow & have fun! Else fight the flow  |
 |
|
|
aiken
Aged Yak Warrior
525 Posts |
Posted - 2005-12-20 : 16:35:17
|
| I think it's very unlikely that SQL server is doing any kind of translation; it doesn't know what data you're storing and isn't even aware that HTML exists.More likely, your app is doing a Server.HTMLEncode() type call on the data either before inserting it or after retrieving it.Cheers-b |
|
|
|
|
|
|
HTML and SQL Server