Editing problems with MySQL

[mabolek]

Hi!

I am using MySQL 5.0.45 with FMP 9.0.3 (in trial mode), and my problem is this:

I am researching the possibilities of editing a customer's MySQL database using FileMaker. Connecting with ODBC works fine, except from the following:

1) The UTF-8 encoded MySQL database content is not shown correctly in FileMaker (I guess because FM is assuming another encoding). I have tried to specify the ODBC encoding as UTF-8, but then FM crashes when I open the project.

2) When editing data loaded from the MySQL database, editing numbers work ok, but editing text results in only one character strings. E.g. changing "hello" to "goodbye" results in "g" only.

I hope you can help!

- Mathias