Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    108

    Unanswered: dts import text file -- max char per line 352?

    I am trying to import a text file into my table.

    However, the max varchar length is automatically set to 352.

    It needs to be longer. Even after manually changing it, sure enough it truncates after 352.

    (We put the first 16 characters into one field, and then try to get the next 800, but it only allows 352)

    Any ideas?

    `Le

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The VARCHAR() datatype can be up to 8000 characters long. If you need more than that, you have my condolences and you need to resort to a TEXT column instead.

    I'm not sure why your data is only importing 352 characters. 255 is a common problem, where people don't reset the maximum column width supported by Query Analyzer from the default value. I don't think I've ever seen 352 as a limit.

    -PatP

  3. #3
    Join Date
    Oct 2005
    Posts
    37
    Don't have answer to question but Pat, how do you modify the max column width in QA to > 255 characters ?

    Cheers

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Hit Shift-Ctrl-o, click the results tab, near dead center.

    -PatP

  5. #5
    Join Date
    Oct 2005
    Posts
    37
    Pat
    Thx that's really cool !

Posting Permissions

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