Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Encoding problems between filemaker and MySQL

AnFrusch@pepp
in External Data Sources

Featured Replies

Hello all,

I'm getting into an encoding problem updating MySQL from FM using Execute SQL script step.

The mysql table has a field which charset is utf8 (utf8_uncode_ci). The field in filemaker contains a lot of characters (arabian, greek, danish..) that once written in MySQL returns only question marks (!).

I tried to use 'SET NAMES utf8' SQL statement before update record and I tried to configure ODBC driver to work with UTF8 charset by default.

Exporting the SQL statement generated from FMpro instead of Execute the query, then copying and pasting the same code into SQLyog (a GUI for MySQL) the characters are correct.. how can I set filemaker to export the proper charset to MySQL?

(FMpro adv. 10 Windows Vista)

  • Author

Up, please

  • 1 year later...

I'm experiencing perhaps the same problem. I have an ESS (MySQL) and receive the ODBC error:

ODBC Error: [MySQL][ODBC 5.1 Driver][mysald-5.1.41-3ubuntu12.8]Incorrect string value: '\xC4\x81bh\xC4\x81...' for column 'Desc' at row 1.

Well, it seems to hate the special characters in the string, "Mahābhārata" a book title.

And so, what is the trick to successfully populated MySQLl with special characters?

tia,

Barbara

Answer: I had to set the encoding on the columns to UTF8_general_ci.

Create an account or sign in to comment

https://fmforums.com/topic/69578-encoding-problems-between-filemaker-and-mysql/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.