AnsweredAssumed Answered

MySQL Text column issue

Question asked by User29172 on Jun 16, 2010
Latest reply on Sep 30, 2010 by TSGal

Summary

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.

Outcomes