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

本文介绍了哪种数据类型会在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，因为您随后将重新引入此限制.请查看此链接: msdn.microsoft/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: msdn.microsoft/en-us/library/cc949109%28v=sql.100%29.aspx[^] Good luck!