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 |
|
mojpro
Starting Member
15 Posts |
 Posted - 2007-04-22 : 14:21:43
|
| Hi, Can you please let me know the diference between these two fields? TEXT and NTEXT?Thanks much, |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-04-22 : 14:45:42
|
From BOL: quote:
ntext: Variable-length Unicode data with a maximum length of 2^30 - 1text: Variable-length non-Unicode data in the code page of the server and with a maximum length of 2^31-1
Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-04-22 : 15:07:43
|
another issue is you shouldn't be using either if you are 2005.you should use varchar(max) and nvarchar(max) instead.
www.elsasoft.org |
|
|
|
mojpro
Starting Member
15 Posts |
Posted - 2007-04-22 : 15:56:11
|
| Thank you Harsh Athalye and jezemine.there are lots of hero in this forums ... :) |
|
|
|
|
|
|
difference between text and ntext field type?