Copying text into a field in the enterprise manager -> no reaction

• Tom De Smet

  Grasshopper

  Points: 14

  More actions

  September 23, 2005 at 11:42 am

  #91316

  Hi,

  I'm inserting some text into my databse tables and I'm copying the text from a word file into the varchar field trough the enterprise manager. I've set the field to 4000 length and the text is about 1600 characters.

  Now, the problem is that he won't copy the text into the datafield. With about 500 chars he copies the text, but not with about 1600. I've tried text, nvarchar, ntext fields but he just doesn't want to copy the whole text into the database. I don't think that my other fields are the matter because they are all together about 500 length. some ints, some smallints and a few varchars from 200 length.

  I'm also using simple european characters, so I really don't understand the problem.

  I hope somebody can help me with this irritating but small problem.

  Thanks!

• Jo Pattyn

  SSC-Dedicated

  Points: 32352

  More actions

  September 24, 2005 at 10:21 am

  #592851

  seems enterprise manager has a limit of 1024 / field

  http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1124064,00.html

• Tom De Smet

  Grasshopper

  Points: 14

  More actions

  September 24, 2005 at 12:11 pm

  #592852

  Thanks so much, guess I'll write my admin panel first then...