mysql限制输入数据,MySQL数据库插入的数据限制

I was wondering if there was a limit to the size of data to be Inserted into a MySQL database?

I seem to be successfully Inserting records but when certain textarea fields get large, it seems like the records won't Insert. Can someone let me know if there is a size limit or if there is just an error?

Thanks.

Brett

解决方案

It depends in the disk and memory size and network limitations mostly:

Quote From my sql website:

The maximum size of a BLOB or TEXT object is determined by its type,

but the largest value you actually can transmit between the client and

server is determined by the amount of available memory and the size of

the communications buffers. You can change the message buffer size by

changing the value of the max_allowed_packet variable, but you must do

so for both the server and your client program