SQL 2008-varchar(max)与文本数据类型 [英] SQL 2008 - varchar(max) vs text data types
问题描述
可能重复:
SQL Server文本类型与varchar数据类型
在SQL Server上使用varchar(MAX)vs TEXT
Possible Duplicate:
SQL Server Text type vs. varchar data type
Using varchar(MAX) vs TEXT on SQL Server
从本文看来,它们都具有相同的大小容量: http://msdn.microsoft.com/zh-CN/library/ms143432.aspx
from this article, it looks like they both have the same size capacity: http://msdn.microsoft.com/en-us/library/ms143432.aspx
那是真的吗?真正的区别是什么?
is that truly correct? what are the real differences?
我只是从oracle(clob)迁移了一些数据,并将其放入varchar(max),但无论如何它似乎都截断了一些值,我应该改用TEXT吗?
i just migrated some data from oracle (clob and made it into a varchar(max), but it looks like it truncated some of the values anyway, should i use TEXT instead?
谢谢!
推荐答案
否,您不应使用TEXT
.例如,自SQL Server 2005起已弃用,而且您还会发现许多字符串操作无法对其进行操作.完全不要使用TEXT
,NTEXT
或IMAGE
-而是使用VARCHAR(MAX)
,NVARCHAR(MAX)
或VARBINARY(MAX)
.
No, you should not use TEXT
. For one, it has been deprecated since SQL Server 2005, and also you will find that many string operations do not work against it. Do not use TEXT
, NTEXT
or IMAGE
at all - use VARCHAR(MAX)
, NVARCHAR(MAX)
or VARBINARY(MAX)
instead.
这篇关于SQL 2008-varchar(max)与文本数据类型的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!