Post reply

DTS import and web form - varchar truncation

  • May 28, 2003 at 12:19 pm

    #357787

    When I import XL files, varchar columns that have text values with more than a couple hundred characters get truncated. I notice that the same file in .txt format seems to import more of the varchar value before truncating.

    I have a similar problem when entering text information on a web form. After about 250 characters, the data is truncated.

    Is there a setting, page size or some other parameter that I can use to accept large text varchar values?

    Thanks.

  • May 28, 2003 at 10:43 pm

    #458945

    What data size and type of column are you importing into? I've had issues with a mixture of numbers and text importing from the same column. I had to make sure the format of the cell in XL was text before importing.

    Darren


    Darren

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

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