varchar(max) 中有多少个字符? [英] How many characters in varchar(max)?

问题描述

当数据类型为 VARCHAR(MAX) 时，SQL Server 2008 数据库字段可以包含多少个字符?

How many characters can a SQL Server 2008 database field contain when the data type is VARCHAR(MAX)?

推荐答案

来自 http://msdn.microsoft.com/en-us/library/ms176089.aspx

varchar [ ( n | max ) ]可变长度的非 Unicode 字符数据.n 可以是从 1 到8,000.max 表示最大值存储大小为 2^31-1 字节.这存储大小是实际长度输入的数据 + 2 个字节.数据输入的长度可以是 0 个字符.varchar 的 ISO 同义词是 char变化或性格变化.

varchar [ ( n | max ) ] Variable-length, non-Unicode character data. n can be a value from 1 through 8,000. max indicates that the maximum storage size is 2^31-1 bytes. The storage size is the actual length of data entered + 2 bytes. The data entered can be 0 characters in length. The ISO synonyms for varchar are char varying or character varying.

1 个字符 = 1 个字节.并且不要忘记用于终止的 2 个字节.所以，2^31-3 个字符.

1 character = 1 byte. And don't forget 2 bytes for the termination. So, 2^31-3 characters.

这篇关于varchar(max) 中有多少个字符?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！