如何从sql server数据库中获取段落大小数据？ [英] How to get paragraph size data from sql server database?

问题描述

我是asp的新手，我想设置动态数据..



制作网站我有完整的页面大小的数据，所以我如何存储该数据在数据库中，可以将其检索到网站..

I am new in asp and i want to set dynamic data..

in making site i have full page size of data so how i can store that data in database and can retrieve it into the site..

推荐答案

你可以使用 HttpUtility.HtmlEncode [ ^ ]和 HttpUtility.HtmlDecode [ ^ ]方法...

You can use HttpUtility.HtmlEncode[^] and HttpUtility.HtmlDecode[^] Methods...

如果要在SQL数据库中存储大量文本，则需要使用varchar（max）或者用于存储该数据的nvarchar（max）列。如果您不知道差异，nvarchar将支持Unicode字符。如果您不确定是否需要Unicode支持，那意味着您可能会使用nvarchar。如果你绝对肯定地知道你不需要它，那么使用varchar（使用一半的空间）。这些列类型的工作方式与您读取和写入它们的方式类似。唯一的区别是，如果数据太大，SQL会将其存储在正常存储之外的磁盘上。这将使检索过程花费更长时间。



我建议你研究这些选项并仔细考虑最适合你情况的方法。

If you want to store large amounts of text in a SQL database, then you want to use either a varchar(max) or a nvarchar(max) column to store that data. In case you don''t know the difference, nvarchar will support Unicode characters. If you aren''t sure if you will need Unicode support, that means you probably will so use nvarchar. If you know for absolute certainty that you won''t need it then use varchar (uses half the space). These column types work like any other column in how you read and write to them. The only difference is that if the data gets too large, SQL will store it on disk outside the normal storage. That will make the retrieval process take longer.

I would recommend you look into these options and carefully think through what is best for your situation.

这篇关于如何从sql server数据库中获取段落大小数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！