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.

Viewing FM text characters in MySQL

Featured Replies

I am intending to transfer data from my FP database to MySQL to be picked up by a third party, but I still need to be able to view it via FP12 where I will use FP12 to create and make amendments to the data. Basically, I guess, it will be a data separation exercise using FP as a UI.

I need to include 'non-text' characters such as tabs, bullet points, etc. in my 'Description' field.

I can create them in FP and import the data into the MySQL database as a TAB file, but when viewing the MySQL data within FP - as a related field from the external data soure [MySQL] - I get, presumably, MySQL's version of the text data which is shown with what I think are symbols for the carriage returns (a kind of 'tadpole with an arrow') and the soft tabs are displayed by a space character.

For example, FP Description field (data as entered):

This is the real test for the MySQL import.

This field will contain all sorts of characters

Soft Tab

Another soft Tab

MySQL version (after import into MySQL);

This is the real test for the MySQL import.(x2 carriage return characters)This field will contain all sorts of characters(x1 carriage return character) Soft Tab(x1 carriage return character) Another soft Tab(x1 carriage return character)

Ironically, when I zoom down or up from 100% the 'tadpole' characters disappear.

Am I doing something that's incorrect? Is it a character set issue?

Any advise would be much appreciated.

Create an account or sign in to comment

Important Information

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

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.