Post reply

trobbels pasting text in a field

  • March 8, 2005 at 7:30 am

    #362106

    Hello I'm new to sql server, I just moved from access.

    I want to paste text into my sql table but it doesn't work.

    the text I want to past is about 1100 characters and I'm using "varchar 8000".

    I cannot paste or even type more than 1023 characters.

    What am I doing wrong?

    Thanks for your help,

    JB

     

  • March 8, 2005 at 9:47 am

    #545918

    Have you tried a datatype of "text"?

    Kindest Regards,

    Seth Washeck

    If nothing in this world satisfies me, perhaps it is because I was made for another world.
    C. S. Lewis

  • March 8, 2005 at 2:46 pm

    #546014

    Can you give us a snippet of your code and the error you are getting? 

    Also, Query Analyzer only displays, (by default) 256 characters.  So if you are seeing your results from Query Analyzer, you may need to change your setting so more data is displayed. 

    I wasn't born stupid - I had to study.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply