What is the length of the data that you are inserting in the text column? I think the limit is 2,147,483,647 characters according to books.
You might be experiencing this issue when you are selecting the ntext column. The number of characters in the result column of SELECT statement are limited. You can check it in options of your query analyzer.
ntext, text, and image data types will be removed in a future version of MicrosoftSQL Server
I know that "The number of characters in the result column of SELECT statement are limited." In Sql Server 2000 it can select only 255 characters I think..... I think that I managed it!! I changed the statement....:
= "insert table (column) values(@text)";
mySqlCommand_new.Parameters.Add(new SqlParameter("@text", SqlDbType.NText));
mySqlCommand_new.Parameters["@code"].Value = text;
is my big text!!! Thanks for your replies!!