do you need to search on it? If not, perhaps storing these files separately with a pointer storedd in the database. This will improve searching speed I understand.
-----Original Message----- From: Lee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 10:29 AM To: MySQL Subject: appropriate datatype - blob/text? Hi, I wonder if someone could offer me some advice. One of the requirements for my database is that it must store (in one field) the contents of a text file (never exceeding 1MB). The data is obviously plain text format, and is in the following format: .0000010 .1083649E+03 .2186916E+02 .0013470 .1993729E+03 .2738670E+02 .0026940 .5308654E+03 .7280664E+02 . . .0040410 .2063586E+04 .2057984E+03 I would like to know what the most suitable and/or efficient method of storage would be. I am assuming BLOB or TEXT. Any advice would be greatly appreciated. - Best regards, Lee <bypass_filter> sql,query </bypass_filter> --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
