Post reply

Cannot insert into varchar(8000) column

  • September 3, 2008 at 12:11 pm

    #197267

    I am trying to insert data of length 1552 into a column of varchar(8000) and the column looks empty after the insert.

    Thanks,

    SSM

  • September 3, 2008 at 1:06 pm

    #866753

    Are there any odd characters in the string? Maybe a carriage return at the front? Do you get any errors returned? What are you using to determine that the field is empty? Does a LEN(fieldname) return zero or 1552? If you try to insert the string into a local variable does it work? Are you inserting into a table or a view? Are there any triggers on the table?

    You may have already gone through all of this, but I'm just dumping some thoughts out.

    Chad

  • September 3, 2008 at 1:08 pm

    #866754

    Can we see the code you are using?

  • September 3, 2008 at 1:18 pm

    #866759

    It was my bad!!!The data was getting inserted,I was not able to see anything in column in the EM.When I used query analyser I saw data in the column.

    Thanks all...

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

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