okay, so mysql long text is 4 G.
however, since the max_alllowed_packet max value is 1G, how do you USE the 4G?
especially in a java app, without running into errors?
currently, I am dumping data from a mssql database into a mysql database, and kept running into errors, until I jacked it up to 1G. Now, I only have a few errors, so how is it supposed to be used, if there's a 1G limit on the amount of data that can be accepted through a query?