OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Couple of questions relating to bext practice.

From: Adam Staunton (adamstlaidley.qld.gov.au)
Date: Thu Feb 05 2004 - 15:45:57 CST

Hi all,

I have had a new mysql db set up and I noticed that the creator has basically given all fields attributes of "longtext", except of course the date fields and some numerical fields. The longtext fields show up as "memo" when I try and view the data in a gui tool etc.

The database has 200 fields and could hold 10000 records over time.

My question is:

Should I be modifying these fields to normal text fields with a length of "x" (x being whatever length necessary for the field), or leaving them as longtext. Leaving them as longtext wouldn't be a good idea , would it ?

any help here would be appreciated.

cheers,

Adam

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql