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.

importing utf data from external to FMP

levonk
in External Data Sources

Featured Replies

Hi,

I am using FMP 9 advanced. I have an external table that I need to import into FM tables so I can use them in Value Lists. The data is on a MySQL server, and I need only two fields (ID and Name).

The Id is importing without problems. The name is a utf8 column. It shows correctly when accessed from MySQL. If there are characters other that roman it that field, the imported field contains question marks instead of the text. I am using the Import Records from ODBC with SELECT.

I found a workaround, which is not that good but it does the job. I export the data to a tab delimited file with utf16 (utf8 is not working), and then I import the data from that file.

Is this a problem with the SQL in FMP or is there something I am doing wrong?

  • Author

I tried the same script on a friend's windows XP machine and it worked fine.

So, is the problem with FMP for mac? Or is it possible that MySQL does not function correctly on Mac?

Create an account or sign in to comment

https://fmforums.com/topic/59660-importing-utf-data-from-external-to-fmp/
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.