Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2006
    Posts
    87

    Unanswered: problem with ntext truncating data

    HI everybody...

    Am inserting data on a form into a ntext field.. our SQL server version is SQL 2000.. everything goes fine but getting the results i've found out that it truncates the data inserted.. editing it gives the same result... What could be the problem in it?

    thanks

  2. #2
    Join Date
    Aug 2006
    Posts
    87
    HI ALL SORRY for this but I found out that the data is not truncated on the field but on the output I'm getting which is where the error is thanks anyway...


    Quote Originally Posted by alexiop
    HI everybody...

    Am inserting data on a form into a ntext field.. our SQL server version is SQL 2000.. everything goes fine but getting the results i've found out that it truncates the data inserted.. editing it gives the same result... What could be the problem in it?

    thanks

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    If you are using Query Analyzer, you can bump up the number of characters displayed through the Options menu. Max is 8000. Default is 256, I think.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •