Find the answer to your Linux question:
Results 1 to 3 of 3
ok what's a good and big container? is longblob ok enough? i'm confused by text and blob. the manual statest that's there's only minimal differences. i chose blob. and i'm ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Linux User
    Join Date
    Aug 2003
    Posts
    289

    container


    ok what's a good and big container? is longblob ok enough? i'm confused by text and blob. the manual statest that's there's only minimal differences. i chose blob. and i'm under the impression that blob and text don't require length specifications and that they go on variable length by default unless you specify it to be of fixed length. is this correct?
    Registered User #345074

  2. #2
    Linux Engineer Giro's Avatar
    Join Date
    Jul 2003
    Location
    England
    Posts
    1,219
    Yes you are correct they will be as long as the data you insert into them. If you have just a large text documet you should use TEXT or CLOB. BLOB should be used for storing large byte strings. You can specify a length of TEXT or BLOB if you want IIRC its
    Code:
    TEXT(1M)
    Where the coloum can store 1M of text you also have (K)ilo (M)ega and (G)iga

  3. #3
    Linux User
    Join Date
    Aug 2003
    Posts
    289
    ok, thanks giro.
    Registered User #345074

Posting Permissions

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