Page 1 of 1

how do i store large data in the database

Posted: Thu Sep 05, 2002 4:31 am
by harsha
hi

i am using mysql database to store the articles and i am unable to store entire article in the table

to store article i am using "text"

should i use longtext or varchar or blob or what should i use??????????

plz help me

Posted: Thu Sep 05, 2002 4:37 am
by noguru
"Text" only allows 65 536 characters, while "longtext" allows 4.2 billion characters. "Mediumtext" falls somewhere in between.

Search the mysql manual for a better explanation:

http://www.mysql.com/doc/