how do i store large data in the database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
harsha
Forum Contributor
Posts: 103
Joined: Thu Jul 11, 2002 1:35 am
Location: Bengaluru (Bangalore) > Karnataka > India

how do i store large data in the database

Post 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
User avatar
noguru
Forum Commoner
Posts: 61
Joined: Thu Jun 06, 2002 4:03 am
Location: Just north of the City Of Gold, Land of Milk and Honey

Post 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/
Post Reply