TEXT field in MSSQL

"String or binary data would be truncated. "

Is the error thrown by my .NET app. However, I'm thinking this might be as a result of a problem with one of the fields in my MSSQL DB.

I have a TEXT field on the database (apparently with a length of 16 ? - Which it seems to set by default). Right, when I tried to insert the following message..... (from quote open to quote end)

"dbahhh hello!.

Have I made myself clear?!?%£$%£$%£$%"$%"££^""£$%"£$%£$"%£$%£%$$%"$£%£$%£$%

special chars.

I."

I got the error "String or binary data would be truncated. " when I try to read that text field back in my .NET app. Can anybody give me even a hint as to why it's not happy to let me view this? Does anybody think this has anything to do with the way SQLS is storing the data? Could it be the special chars? How does the TEXT field handle special chars? Or doesn't it?

I've tried inserting data without the special chars, e.g. :

"Hi, hello , goodbye...

Thanks " - and that works fine - it's just the above that seems to be an issue.

Any help is much appreciated. And I apologise - this is a borderline .net / mssql question, which unforunately doesn't fit cleanly under either forum.

Thanks in advance!

I.

I have fixed this now - was something to do with the length of one of my fields.....