如何保存在SQL服务器的HTML数据
我有反馈面板,用户可以通过编写HTML格式化反馈 AJAX HTML编辑
I have feedback panel where user can write HTML formated feedback using AJAX HTMLEditor
我要保存在SQL Server此HTML数据
I want to save this HTML DATA in SQL server
HTML源代码
This is <span style="font-weight: bold; ">nice</span> question
HTML输出
This is nice question
现在我怎么可以搜索到我的数据库,如果你的发现是好的,那么我的查询不能反应很好,因为数据库包含HTML标签了。
Now how can i search to my database if your find "is nice" then my query can not response is nice because database contains HTML tags too.
那么,保存和使用SQL查询和检索放HTML数据的最佳做法; ASP.net。
So what are best practices to save and retrieve HTML data using SQL Query & ASP.net.
您可能会得到一些里程了SQL Server的全文搜索功能。这里是一个描述应用全文搜索到HTML文本存储在SQL Server的战略资源:
You might get some mileage out the SQL Server's full-text search capability. Here is a resource that describes strategies to apply full-text search to HTML text stored in SQL Server:
的http://www.developmentnow.com/blog/SQL+Server+2005+Full+Text+Search+On+HTML+Documents.aspx