TEXT field truncate to 255 symbols ?!?!?!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello !
I"m trying to insert large string (more than 1000) into TEXT field in SQL
Server but it truncate the data to 255 symbols. Is there any other way to
insert large string into TEXT field without using WRITETEXT and UPDATETEXT?
Just from ADO.NET?
Till this moment I try to execute query with SQLParametersCollection (with
SQLDbType.TEXT) and query just like a string - the result is the same : only
255 symbols..
Kind regards,
Toma
 
Plz make sure that your TEXT field length large than 1000 firstly.
If no problem about this, you can use SQL Event Inspector in MSSQL
tools to trace SQL language. you will find what happened about SQL.

Sincerely,
simida
 
Back
Top