I've been working on a problem that involves translating an Oracle database into MySQL. The conversion process has been working great – thanks to the great conversion tool provided by Intelligent Converters. Unfortunately, we hit a snag with it earlier this week.

Because of our specific requirements, we are storing som docs and images in the database as a LARGEBLOB. After inserting the converted data into MySQL, some of the larger files were being truncated.

After troubleshooting, we figured the problem was with the conversion/insertion process. To get around this, we had to increase the MAX_ALLOWED_PACKET to 16M and get a modified version of the Oracle to MySQL too. Problem solved!