Developing a database to capture data from a form, where some fields will require visitors to enter essays several pages in length. What's the largest field size for TEXT in MySQL?
2007-03-09 12:11:56 · 3 answers · asked by Mirza Hakimi 1 in Computers & Internet ➔ Programming & Design
TEXT (if i'm to guess from the storage requirement) is about 65k characters.
If you need more you can look into using MEDIUMTEXT (16 million bytes) or LONGTEXT (4 billion bytes).
2007-03-09 12:26:21 · answer #1 · answered by mackn 3 · 0⤊ 0⤋
Well if u only hv to store ur data somewht on txt format den u shud not worry abt. d field size....but still u can make sure about dat in d Help of MySQL or can refer its pre-compiled Help Files........
visit http://www.mysql.com for Online Inquiry.....
Best of Luck
2007-03-09 20:21:52 · answer #2 · answered by himanshu dadhich 2 · 0⤊ 1⤋
this should completely answer your question:
http://help.scibit.com/Mascon/masconMySQL_Field_Types.html
2007-03-09 20:35:02 · answer #3 · answered by Jeffrey F 6 · 0⤊ 0⤋