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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
