哪种数据类型会在sql中引发无限数据 [英] which data type stroes unlimited data in sql

问题描述

哪种数据类型会在sql中引发无限数据

which data type stroes unlimited data in sql

推荐答案

这是我在msdn上发现的有关此数据类型的内容

ntext
可变长度Unicode数据，最大长度为2 ^ 30-1(1,073,741,823)个字符.存储大小(以字节为单位)是输入字符数的两倍. ntext的ISO同义词是国家文本.

文字
服务器代码页中的可变长度非Unicode数据，最大长度为2 ^ 31-1(2,147,483,647)个字符.当服务器代码页使用双字节字符时，存储空间仍为2,147,483,647字节.根据字符串，存储大小可能小于2,147,483,647字节.

有关更多信息，请检查以下线程:
ntext，文本和图像 [字符和varchar [

This is what I found regarding this data type on msdn

ntext
Variable-length Unicode data with a maximum length of 2^30 - 1 (1,073,741,823) characters. Storage size, in bytes, is two times the number of characters entered. The ISO synonym for ntext is national text.

text
Variable-length non-Unicode data in the code page of the server and with a maximum length of 2^31-1 (2,147,483,647) characters. When the server code page uses double-byte characters, the storage is still 2,147,483,647 bytes. Depending on the character string, the storage size may be less than 2,147,483,647 bytes.

For more you can check following threads:
ntext, text, and image[^]
char and varchar[^]

Hope it helps.

限制为2gb.为了克服这个问题，您可以使用文件流功能. (当然)所使用的文件系统必须不是FAT32，因为您随后将重新引入此限制.请查看此链接: http://msdn.microsoft.com/zh-CN -us/library/cc949109％28v = sql.100％29.aspx [

The limit is 2gb. To overcome this you can use the filestream feature. The filesystem used must (of course) not be FAT32 because you would then reintroduce this limit. check out this link: http://msdn.microsoft.com/en-us/library/cc949109%28v=sql.100%29.aspx[^]

Good luck!

这篇关于哪种数据类型会在sql中引发无限数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！