FM sends truncated data to MYSQL

[Delta Tango]

Hey Everyone,

I have been using FM to access a mysql database.

I am able to connect and view data perfectly, add/delete records.

However, I am having a serious problem updating external records.

When I change a field's data and commit the record, the entire data gets chopped after the first character.

A field that gets "abc123" typed into it and then committed, results in "a".

Has anyone had this same problem??

It is driving me crazy.

Thanks

[bruceR]

You will need to describe what platform you are on and what driver and driver version you are using.

[Delta Tango]

Bruce,

thanks for the response. i am on a mac osX latest update (10.4.10).

I am using the odbc administrator and the latest mysql odbc driver.

[bruceR]

FileMaker very clearly states that the only driver supported for this purpose (MySQL/OSX) is the one from Actual Technologies.

See http://www.filemaker.com/support/technologies/sql.html

Edited October 8, 2007 by Guest