Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-14 : 09:20:52
|
| Marcio writes "For most of the lengths that shows in the column length when creating a new table in SQL Server, the value means bytes. For instance, a tinyint and bit = 1 (byte), smallint = 2 (bytes), int = 4 (bytes), and bigint = 8 (bytes). However, for text datatype the number that shows up is 16.What that 16 really means ?" |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-03-14 : 09:26:58
|
| Text, ntext and image data is not stored in the table itself. All that exists in the table is a 16-bit pointer to the actual location where the data is stored. In SQL2k you can set an option to store short text values in the table itself. |
 |
|
|
|
|
|
Length value showed when creating a column