hey all,
how would i write to a text file on my server and read from it again??
thanks :)
Printable View
hey all,
how would i write to a text file on my server and read from it again??
thanks :)
whats the purpose for this ? pretty-much everything that can be stored in a text file can be stored in a database instead :p
Not if you're making a program to create and modify your webpage. :eek:Quote:
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 :p
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
A DB will fit as much as you will ever need.
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.Quote:
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.
Quote:
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)