text , ntext datatypes ( PLEASE HELP )

[abdelhameed81]

hi all every time i add a column to my table with the type text or ntext all what is entered in the database is only the first 16 characters. it happened also with all my colleagues plz help me with this problem abdelhameed81

[Mark Salsbery]

How is the column defined? How are you inserting text into the column? Mark

[abdelhameed81]

the column is created in the design view of the SQL enterprise manager and the data is inserted to it from an ASP.Net application abdelhameed81

[Jerry Hammond]

FWIW text is a datatype that will be deprecated in future versions of SQL Server. Keep that in mind as you develop your tables. varchar or nvarchar are the best choice in my nosey opinion.

"We've all heard that a million monkeys banging on a million typewriters will eventually reproduce the entire works of Shakespeare. Now, thanks to the internet, we know this is not true." -- Professor Robert Silensky

[Mark Salsbery]

What is the max length of the text for the column? I meant can you post code snippet showing how you do the insert? Database is SQL Server? Mark