Sending large amounts of text to MySQL

[filburt1]

Originally Posted by Tekton

To ask the question he might have though, what IS the default... and is the cnf file value in # of characters?

The default is 1 MB (1024 * 1024, so 1048576 characters). If you're uploading files or inserting binary data into a database, it should be far larger. I happened to be working on BLOB data types for vBMS recently which is why I was looking into this. Make sure you check filesizes against max_packet_size. You can get the value of that variable via:
[sql]
SHOW VARIABLES LIKE "max_packet_size"
[/sql]
The column name it returns for the value is "Value" (that same case).