Thank you for your post.
It's difficult for me to determine where the "max length of 65535 characters" was defined. Was this defined in the FileMaker field options or in the VARCHAR parameter of the MySQL column? The driver setting would not affect the column size.
The field validation options for the MySQL column show in FMP with a checked, dimmed value for maximum number of characters: 65535 which is the maximum amount of data that a Text column can hold.
I was also incorrect in my original post about 2048 characters. What we're really seeing is that the field gets cut off at 8192 characters.
We had this problem with SQL Server, so I can't comment directly on MySQL. However, SQL Server had two drivers. One is named "Native Client". It works. The other driver truncated the text data, just as you are describing. Might be worth a look, to see if they have an alternate driver.
Thanks for the tip. We use the SQL Native driver as well for a few databases.
On the MySQL side, FileMaker only seems to work with the older 3.51.14 driver. (MySQL had several other releases in the 3.51 stream dating back to 2008 and is has been distributing a 5.1.x release for some time)
This one fell through the cracks, so I apologize for the late reply.
Our Development and Software Quality Assurance (Testing) departments are aware of this issue. In essence, as you discovered, only the first 8192 characters appear from a Text column when using MySQL. The other ESS drivers (SQL Server and Oracle) do not have this issue. If you enter more than 8192 characters into the field, it will write correctly back to MySQL, but only 8192 characters will appear in FileMaker Pro. There is no workaround at this time.