Anybody having success with MySQL/FM9 on Windows?

[Paul Grayson]

Hello,

We are trying to implement a connection between Filemaker and a MySQL database at the small business where I work. Filemaker 9 got us feeling very optimistic because of its ability to make the MySQL tables appear as normal tables alongside other tables in a Filemaker database, but after using this feature for a while, we have run into a couple of bizarre problems.

The most annoying problem is that Filemaker seems to truncate text fields to 8 or 16 kilobytes, depending on the installation, which is just unacceptable for almost any kind of database application and so out of line with Filemaker's normal abilities that I am really hoping there will be an easy solution. So, has anyone out there successfully used the MySQL/FM9 connection to view or modify fields containing hundreds of kilobytes or more?

I'd really appreciate hearing about your experiences with the new FM9 connection as well as any tips you have to offer.

I have verified this problem under both XP and Vista, and I have confirmed that it is not an ODBC driver problem: Openoffice Base is able to access the entire record without truncation, through exactly the same DSN. So I'm 99% sure that Filemaker is doing something silly here. I have not tried it on a Mac, but I would be interested in hearing about whether it works there, too.

Thanks for your help!

-Paul