MySQL Text column issue
Description of the issue
Have windows 2003 server running FMS 11 with MySQL 3.51.14 driver pointing at MySQL 5.x database. Clients are running FMP v11. Have a table with a few columns, one being a Text column. The table adds correctly and in field is defined with a max length of 65535 characters. However, only the first 2048 characters of the text field appear. If a record is edited, the column is then truncated to the displayed 2048 characters. However, if we paste a value into the field then > 2048 characters can be written to mysql. There aren't any driver settings for column size. Wondering what the issue may be. Had the same issue with FMS10.