Results 1 to 9 of 9

Thread: writing to a file

  1. #1

    Thread Starter
    Lively Member DJ P@CkMaN's Avatar
    Join Date
    Jan 2002
    Location
    Burpengary, Queensland, Australia
    Posts
    95

    writing to a file

    hey all,

    how would i write to a text file on my server and read from it again??

    thanks
    There's something I've noticed in the last year or so...
    Australian's are good at EVERYTHING !!!

  2. #2
    Fanatic Member ubunreal69's Avatar
    Join Date
    Apr 2001
    Location
    Morayfield, Australia
    Posts
    609
    whats the purpose for this ? pretty-much everything that can be stored in a text file can be stored in a database instead

  3. #3
    Fanatic Member Gimlin's Avatar
    Join Date
    Dec 2001
    Location
    Hell
    Posts
    734

  4. #4
    Stuck in the 80s The Hobo's Avatar
    Join Date
    Jul 2001
    Location
    Michigan
    Posts
    7,256
    Originally posted by ubunreal69
    whats the purpose for this ? pretty-much everything that can be stored in a text file can be stored in a database instead
    Not if you're making a program to create and modify your webpage.
    My evil laugh has a squeak in it.

    kristopherwilson.com

  5. #5

    Thread Starter
    Lively Member DJ P@CkMaN's Avatar
    Join Date
    Jan 2002
    Location
    Burpengary, Queensland, Australia
    Posts
    95
    the reason i was going to use a text file was that i need to store alot of info (about 1 or more pages) and i wasnt sure if i could fit that into one database record
    There's something I've noticed in the last year or so...
    Australian's are good at EVERYTHING !!!

  6. #6
    Fanatic Member Gimlin's Avatar
    Join Date
    Dec 2001
    Location
    Hell
    Posts
    734
    A DB will fit as much as you will ever need.

  7. #7

    Thread Starter
    Lively Member DJ P@CkMaN's Avatar
    Join Date
    Jan 2002
    Location
    Burpengary, Queensland, Australia
    Posts
    95
    well would you able to tell me how?? the varchar() can only hold up to 255 characters and i dont know how to make it hold more.
    There's something I've noticed in the last year or so...
    Australian's are good at EVERYTHING !!!

  8. #8
    Stuck in the 80s The Hobo's Avatar
    Join Date
    Jul 2001
    Location
    Michigan
    Posts
    7,256
    Originally posted by DJ P@CkMaN
    well would you able to tell me how?? the varchar() can only hold up to 255 characters and i dont know how to make it hold more.
    Use the Text datatype. It can hold as much as you need.
    My evil laugh has a squeak in it.

    kristopherwilson.com

  9. #9
    Fanatic Member Gimlin's Avatar
    Join Date
    Dec 2001
    Location
    Hell
    Posts
    734
    Column type Storage required
    CHAR(M) M bytes, 1 <= M <= 255
    VARCHAR(M) L+1 bytes, where L <= M and 1 <= M <= 255
    TINYBLOB, TINYTEXT L+1 bytes, where L < 2^8
    BLOB, TEXT L+2 bytes, where L < 2^16
    MEDIUMBLOB, MEDIUMTEXT L+3 bytes, where L < 2^24
    LONGBLOB, LONGTEXT L+4 bytes, where L < 2^32
    ENUM('value1','value2',...) 1 or 2 bytes, depending on the number of enumeration values (65535 values maximum)
    SET('value1','value2',...) 1, 2, 3, 4 or 8 bytes, depending on the number of set members (64 members maximum)

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