text too large?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Stijn Goris
    #1

    text too large?

    hi all,

    My problem: when inserting a large text (from a textarea) into the database
    it just wont happen. When the text is somewhat smaller no problem occurs.
    The large text is about 100 lines * 60 characters (not that big at all). The
    field I insert is a TEXT type so that couldn't be the problem.

    Someone can help me out?

    kind regards
    Stijn


    Tags: None
    • Sharif Tanvir Karim
      #2
      Re: text too large?

      "Stijn Goris" <mepisto@hotmai l.com> wrote in message
      news:Hovlb.9768 7$ll6.4536447@p hobos.telenet-ops.be...[color=blue]
      > hi all,
      >
      > My problem: when inserting a large text (from a textarea) into the[/color]
      database[color=blue]
      > it just wont happen. When the text is somewhat smaller no problem occurs.
      > The large text is about 100 lines * 60 characters (not that big at all).[/color]
      The[color=blue]
      > field I insert is a TEXT type so that couldn't be the problem.
      >
      > Someone can help me out?
      >
      > kind regards
      > Stijn
      >[/color]

      What exactly is your problem? After inserting the text, is it cutoff at a
      certain point in the database? The length of the TEXT field in the database
      is also important, make sure there isn't a specified length.
      --
      Sharif Tanvir Karim
      http://www.onlyonxbox.net



        Comment

        • Matthias Gutfeldt
          #3
          Re: text too large?

          Stijn Goris wrote:[color=blue]
          > hi all,
          >
          > My problem: when inserting a large text (from a textarea) into the database
          > it just wont happen. When the text is somewhat smaller no problem occurs.
          > The large text is about 100 lines * 60 characters (not that big at all). The
          > field I insert is a TEXT type so that couldn't be the problem.[/color]

          Which database are you using?
          What error messages do you get from the database?

          What's the maximum length of a TEXT column type in the database you're
          using? In MySQL it's "a maximum length of 65535 (2^16 - 1) characters"
          according to <http://www.mysql.com/doc/en/Column_types.ht ml>.


          Matthias

            Comment

            • Stijn Goris
              #4
              Re: text too large? -&gt; problem solved


              "Stijn Goris" <mepisto@hotmai l.com> wrote in message
              news:Hovlb.9768 7$ll6.4536447@p hobos.telenet-ops.be...[color=blue]
              > hi all,
              >
              > My problem: when inserting a large text (from a textarea) into the[/color]
              database[color=blue]
              > it just wont happen. When the text is somewhat smaller no problem occurs.
              > The large text is about 100 lines * 60 characters (not that big at all).[/color]
              The[color=blue]
              > field I insert is a TEXT type so that couldn't be the problem.
              >
              > Someone can help me out?
              >
              > kind regards
              > Stijn
              >
              >[/color]

              addslash() did the job. Query was blokked when ' was read


                Comment

                Previous template Next
                Working...