It sounds like when you say "text" what you really mean is the varchar() type. If you declare a field as a text type, you can store 2^16 characters, or 65,536 characters.
From http://dev.mysql.com/doc/mysql/en/Storage_requirements.html the text types are:
tinytext = 2^8 = 256 characters (same as the max for varchar())
text=2^16=65,536 characters = 65 kilobytes (the old maximum size document Notepad was capable of opening, pre-windows 2000)
mediumtext=2^24=16,777,216 characters=16 megabytes
longtext=2^32=4,294,967,296 characters= 4 gigabytes of data
If you wanted to store pictures or mp3's or other binary data in the database, you'd use blob types instead of text with the same storage capabilities.
bob
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]