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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Make Table Query Truncating Memo Field at 255 Characters 2
FIeld with more than 255 char on report 0
Memo Field is truncating to 255 Chars 6
text box in report is truncating memo field at 255 characters 2
insert memo feild into a memo field truncates at 255 characters - 4
Truncation of memo fields using DoCmd.TransferText acImportDelim, 1
RunSql string shorten to 255 characters 1

Back
Top