Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2005
    Location
    Milwaukee, WI
    Posts
    105

    Unanswered: INSERT into TEXT is Truncating

    I have an application that issues the following against a SQL server table called SQLTEST:

    sqltest.TT_MEMO is a TEXT type field
    mmvar has about 5k worth of character data

    INSERT INTO SQLTEST (TT_MEMO) values (?mmvar)

    PROBLEM: the mmvar is getting truncated to 1024 characters

    What can I do to rid the truncation?

    Thanks,

    Peter

  2. #2
    Join Date
    Mar 2005
    Posts
    71
    isnt a TEXT data type maxed out at 1024. i think you will have to use a MEMO data type.

  3. #3
    Join Date
    Feb 2005
    Location
    Milwaukee, WI
    Posts
    105
    According to BOL - TEXT can hold up to 2gig of data.

  4. #4
    Join Date
    Mar 2005
    Posts
    71
    My apologies, you are correct I was coming at it from a Delphi 5 perspective.

  5. #5
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Quote Originally Posted by Pdiotte

    PROBLEM: the mmvar is getting truncated to 1024 characters

    What can I do to rid the truncation?
    Is the data being truncated, or your display in Query Analyzer? If it is the latter, click on Tools -> Options -> Results and change your "maximum characters per column" value to something larger than 1024. Then click OK or Apply to apply the new value.

    -- This is all just a Figment of my Imagination --

  6. #6
    Join Date
    Feb 2005
    Location
    Milwaukee, WI
    Posts
    105
    Tom:

    Wow - you are dead on sir! I feel foolish. I extracted the data back out of the SQL Server table - and it was all there.

    My approach of simply highlighting a field in a QA result set and copying and pasting is not a good approach.

    I also did your suggestion of increasing the maximum "column width" and my approach yielded more data.

    Thank you very much!

    Peter

Posting Permissions

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