Results 1 to 5 of 5

Thread: [Resolved] MySQL: TINYTEXT, MEDIUMTEXT, LONGTEXT...

Threaded View

  1. #1

    Thread Starter
    Stuck in the 80s The Hobo's Avatar
    Join Date
    Jul 2001
    Location
    Michigan
    Posts
    7,256

    [Resolved] MySQL: TINYTEXT, MEDIUMTEXT, LONGTEXT...

    What's the difference, besides size, in all of these? Is there any drawbacks to using them?

    If I know that a field will never have more than 500 characters, should I then use MEDIUMTEXT? Would it use up more memory to just go with TEXT?

    In fact, what are the sizes? I think TINYTEXT is 255. If so, what's the difference between that and VARCHAR (since it can go up to 255).
    Last edited by The Hobo; Oct 11th, 2003 at 05:42 PM.
    My evil laugh has a squeak in it.

    kristopherwilson.com

Posting Permissions

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



Click Here to Expand Forum to Full Width