Results 1 to 12 of 12
  1. #1
    Join Date
    Jul 2004
    Posts
    10

    Unanswered: Long text column not accepting

    Hi DBAs,
    I am very new in SQL server. I created a table where one column is varchar(8000). But when I am trying to insert value from enterprise manager this column cann't accept a long text value. I counted that its' capacity is 1012 charecters. I have tried a lot but don't know how to solve this. I really need help from you. Pls help.

    Thanks in advance

    Rajat Raychaudhuri

  2. #2
    Join Date
    Jul 2004
    Posts
    10
    I am under pressure , pls advice me soon

  3. #3
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Use Query Analyzer.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Have you tried using INSERT statement from QA? What's the total length of your record?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  5. #5
    Join Date
    Jul 2004
    Posts
    10
    Thanx friends. From Query Analyzer it worked.
    Rajat

  6. #6
    Join Date
    Jul 2004
    Location
    Irvine, CA
    Posts
    7

    varchar(8000)

    If you are new to this, one quick note. SQL Server's Row Byte size is limited somewhere right around 8k bytes for physical data stored in the database. So, if the table has other columns in it, you might be in for trouble. Switching a very large column to Text may save you some future hassle. Of course, it could cause you a little hassle right now.

  7. #7
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    I respect people that appreciate the value of TEXT/IMAGE datatypes
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  8. #8
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    A little hassle now??? That's not near as much hassle as it could cause him down the road.

    RANT OFF

    Go ahead...your turn now.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  9. #9
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    TEXT/NTEXT/IMAGE columns definitely have their place. They can do things that are otherwise impossible in SQL Server. I don't see them as substitutes for VARCHAR or NVARCHAR any more than I see DATETIME as a substitute... Under certain rigorous conditions any of them might work, but as a generic substitute they are poor choices.

    -PatP

  10. #10
    Join Date
    May 2004
    Posts
    3

    how to Switch

    Switching a very large column to Text






    -----------------------------------
    http://www.3-ibm.com

  11. #11
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Is this a question? And how large is "very large"?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  12. #12
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    I think he means it's veeeeeeeeeeeeeeeery large.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

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