Re: BLOB and LONGTEXT question

2001-07-25 Thread Paul DuBois
At 10:11 PM -0500 7/25/01, Mike wrote: I have throughly looked at the documentation and I am beginning to get frustrated. It says that a LONGTEXT field's max length is L+4 bytes, where L 2^32. I understand the extra 4 bytes(+4) which is to keep track of the size sense LONGTEXT is no more than

Re: BLOB and LONGTEXT question

2001-07-25 Thread Mohamad Ilhami
On Wed, 25 Jul 2001, Paul DuBois wrote: I doubt if they are trying to irritate you. The maximum size of a MySQL database depends on your file system constraints, not on the size of a LONGTEXT. Some OSes have a max file size of 2GB, for example; others don't. Linux ext2 filesystem only