Best data type for long text(for news system)

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
nimrodm
Forum Newbie
Posts: 4
Joined: Sun Nov 09, 2008 8:28 am

Best data type for long text(for news system)

Post by nimrodm »

Hi. im building a news system with php and mysql...
im not sure what kind of data type should i use for my main part.
Should i use long text or varchar or anything else?! what do you guys recommend?

thanks
User avatar
novice4eva
Forum Contributor
Posts: 327
Joined: Thu Mar 29, 2007 3:48 am
Location: Nepal

Re: Best data type for long text(for news system)

Post by novice4eva »

depends on how much data you are inserting. This is where you would like to search for more detail:
http://dev.mysql.com/doc/refman/5.0/en/ ... rview.html
Post Reply