I am using microsoft sql server 2005 and I am saving text that could be 25000 char long. In the database we are using ntext data type which can handle a big string. What datatype do we use to get the ntext datatype and how do we do it. When I did some research it looks like I need to use a CLOB but have never used it before. I originally thought I needed to use datatype of Byte[] but now think I need string. If I use string it only allows 4k I would have to break it up somehow.
Anyways I hope you understand what I am trying to get.
Start Free Trial