SitePoint Sponsor

User Tag List

Results 1 to 8 of 8
  1. #1
    SitePoint Member tscratch's Avatar
    Join Date
    May 2001
    Location
    Florida
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Problem: TEXT, MEDIUMTEXT Data types.

    Hello everyone.
    I am having a problem with TEXT fields and MEDIUMTEXT fields. The smaller of the two of these ids supposed to hold over 65k characters.

    I created a test table and set one of the fields to TEXT. When I tried to insert a record the text column stopped accepting after about 250 characters. I figured I could deal with this by using a MEDIUMTEXT field, but it does the same thing.

    I am using mysqld-opt and entering SQL into the command line. Does anyone know why I am having this problem? Do I need to add something to the my.cnf file?

    I am trying to break my MS addiction one step at a time and could use a little help with this problem.

    MySql ver 3.23.41
    mysqld-opt
    Win 98

    TIA,
    --
    Eric

  2. #2
    SitePoint Member tscratch's Avatar
    Join Date
    May 2001
    Location
    Florida
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    No ideas for help on this one, huh?
    --
    Eric

  3. #3
    Victory shall be mine tubedogg's Avatar
    Join Date
    Mar 2001
    Location
    Medina, OH
    Posts
    440
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    When you say "stopped accepting" what exactly do you mean?
    Kevin

  4. #4
    SitePoint Member tscratch's Avatar
    Join Date
    May 2001
    Location
    Florida
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi! Thanks for reply!

    The window stops accepting input. It's going, going, and it just stops in the middle of a wor

    It wont let me put in any more characters. I have to back up two spaces just to close the statment (the '
    -edit- this was not supposed to be a smiley, it's the ' and the ; at the end of the statement -/edit-

    This is really driving me crazy I started with the excellent article here on SP and everything is working except for this db problem. I have looked every place I can think of, mysql.com, the manual, all of my (2) smart friends...
    --
    Eric

  5. #5
    SitePoint Wizard Defender1's Avatar
    Join Date
    Apr 2001
    Location
    My Computer
    Posts
    2,808
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    your having this problem in the command line?
    i havne't used this, is it similar to telnet?
    if so, just hit return w/o the ;
    it should give you a new line to continue to type in.
    Defender's Designs
    I'm Getting Married!

    Not-so-patiently awaiting Harry Potter Book 7 *sigh*

  6. #6
    SitePoint Member tscratch's Avatar
    Join Date
    May 2001
    Location
    Florida
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Once it reaches a certain point it won't accept ANY keyboard input other than a backspace.
    --
    Eric

  7. #7
    Victory shall be mine tubedogg's Avatar
    Join Date
    Mar 2001
    Location
    Medina, OH
    Posts
    440
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You're using DOS, yes?
    It isn't actually MySQL...it's DOS limiting your input. You can try one of two things:
    First, do as Defender suggested. When you get to the point of not being able to type anymore, hit backspace once and hit enter and continue typing. Repeat this as many times as necesssary.
    Or put your input into a PHP file and use PHP to insert it into the database.
    Kevin

  8. #8
    SitePoint Member tscratch's Avatar
    Join Date
    May 2001
    Location
    Florida
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks guys,

    I did the enter and then add more text. That worked but it adds extra space to the table. Since I am learning mysql to support php data site, i will just use forms to add the content. I was doing it manually just to get up-close and personal with sql.

    Thanks again.
    --
    Eric


Bookmarks

Posting Permissions

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