#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Posts
    8
    Rep Power
    0
    I am finishing up a chat room that uses a mySQL database. I figured I could stored the messages as TEXT datatypes. However, the TEXT datatype length is 65535 bytes, so I cannt append anymore data after that limit is reached.

    Does anyone know if it is possible to change the limit OR possibly a beter way to store the message data?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    43
    Rep Power
    15
    The following is out of the mysql manual:

    BLOB
    TEXT
    A BLOB or TEXT column with a maximum length of 65535 (2^16 - 1) characters. See section 7.7.1 Silent column specification changes.
    MEDIUMBLOB
    MEDIUMTEXT
    A BLOB or TEXT column with a maximum length of 16777215 (2^24 - 1) characters. See section 7.7.1 Silent column specification changes.
    LONGBLOB
    LONGTEXT
    A BLOB or TEXT column with a maximum length of 4294967295 (2^32 - 1) characters. See section 7.7.1 Silent column specification changes.


    ------------------
    webpatron.com

Similar Threads

  1. DIV scroll with image scroll buttons
    By CarlosFratini in forum HTML Programming
    Replies: 5
    Last Post: May 21st, 2004, 09:58 AM
  2. Mouse over questions. n00b. :o
    By Not Tony Danza in forum HTML Programming
    Replies: 2
    Last Post: December 2nd, 2003, 07:28 AM
  3. TEXT datatype in MySQL for Windows
    By JaMmed in forum MySQL Help
    Replies: 2
    Last Post: November 10th, 2003, 02:41 AM
  4. text file to MySQL
    By scrtagt69 in forum PHP Development
    Replies: 7
    Last Post: July 8th, 2002, 12:33 PM
  5. Trouble importing text file into MySQL
    By Dion in forum MySQL Help
    Replies: 7
    Last Post: August 10th, 2001, 08:08 PM

IMN logo majestic logo threadwatch logo seochat tools logo