September 21, 2012 at 11:47 am
Good Afternoon Guys,
i am currently using the varchar(Max) in storing a large chunk of string in the our Database(Sql Server 2008) but i would want to ask if i can use Text or ntext in saving a large string of data on a sql Server 2000 table? i know that the (max) option for varchar is not yet present in sql server 2000 so i would want to know if ntext or text should be a viable substitute for saving a large string in sql server 2000. any thoughts on this one guys?
Best Regards,
Noel
September 21, 2012 at 11:58 am
Text/NText is the SQL 2000 version of (n)varchar(max).
Whether it will work or not depends on how you're using the data. For example, most of the string functions won't work on Text datatype. There are special methods for editing them, instead of Stuff() or Replace(), and so on. So it really depends on whether the application or procs are written to deal with the special needs of Text.
If so, then you should be fine. They can pass data back and forth without loss between the two data types.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 21, 2012 at 1:26 pm
Hi Gsquared.
Thanks for giving me an advice on this problem. i will be testing my code for this one later and give you feedback on this one. again much thanks
Best Regards,
Noel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply