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 |
|
Zath
Constraint Violating Yak Guru
298 Posts |
 Posted - 2007-01-05 : 08:51:36
|
| I need a little clarification on a certain data type - textNow, it's max is: Variable-length data with a maximum length of 2^31 - 1 characters And in the table I have, the length is set to 16.Is this the max and how can it be calculated with this number?Thanks,Zath |
|
|
Zath
Constraint Violating Yak Guru
298 Posts |
Posted - 2007-01-05 : 09:16:39
|
| Nevermind. Just noticed that the 16 can NOT be changed.....I'm glad it's friday!!!!!Zath |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-05 : 09:17:58
|
| Just FYI, the length 16 which you saw for text column is the size of 16-byte text pointer. It has nothing to do with size of actual text stored. That's why the difference.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
data type text max length