Forums
This topic is locked
ntext in SQL 2000
Posted 28 Jan 2002 22:41:02
1
has voted
28 Jan 2002 22:41:02 Derek Lofgreen posted:
<font face='Verdana'>I have a table with a field that is a ntext data type. It does not accept any inserts or updates. It works fine when the data typ is char. How do I get it to accept data?</font id='Verdana'>Replies
Replied 28 Jan 2002 22:51:16
28 Jan 2002 22:51:16 Viktor Farcic replied:
I encountered same problems with text type. Simply use nvarchar and set it to some large number.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
<font face='Verdana'>I have a table with a field that is a ntext data type. It does not accept any inserts or updates. It works fine when the data typ is char. How do I get it to accept data?</font id='Verdana'>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Viktor Farcic
TalkZone Manager
Edited by - vfarcic on 28 Jan 2002 22:54:11
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
<font face='Verdana'>I have a table with a field that is a ntext data type. It does not accept any inserts or updates. It works fine when the data typ is char. How do I get it to accept data?</font id='Verdana'>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Viktor Farcic
TalkZone Manager
Edited by - vfarcic on 28 Jan 2002 22:54:11
Replied 29 Jan 2002 09:55:20
29 Jan 2002 09:55:20 Viktor Farcic replied:
I've been searching a little and this is what I've found:
www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=138
Viktor Farcic
TalkZone Manager
www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=138
Viktor Farcic
TalkZone Manager