© Microsoft Corporation. All rights reserved.
TABLE 1: Natural BLOB Data Types | ||
Data Type | Description | Maximum Length |
Image | Used for variable-length | 231 1 (2,147,483,647) |
binary data | ||
Text | Used for non-Unicode | 231 1 (2,147,483,647) |
variable-length text data | ||
Ntext | Used for Unicode | 230 1 (1,073,741,823) |
variable-length text data |