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.

Filtering non-latin charecters in portal

Featured Replies

Hi!

I tried everything and nothing works if you have forein characters other than latin to filter a portal. It doesn't find anything at all! I tried many ways like "ASCII" characters in fields, etc. Nothing will do frown.gif I use an English version of Windows with Greek character support and the only compatible font with the least problems, "Arial Greek". Any hints?

Is there something i could do, or is Filemaker not supporting it?

Thanks

Hello Mastichis,

If you choose the ASCII indexing option for the key field in your related database (ie the field which appears in the right-hand column in the Define Relationships dialog) then relationship matching will be based one the entire ASCII character set.

Indexing options are set via the 'Storage' tab in the Options dialog for the field, which is accessed via the Define Fields window.

With the ASCII indexing setting in place for the target key field, ~!|@# will match to ~!|@#, but will not match to ~!/@#, and

  • Author

Hello,

Well I tried what you suggested and it still don't work. To give a wider view, I have a global field filtering a portal with a list of names. I have for each alphabet letter a button that when clicked the global field is updated with the letter which was clicked. I tried the storage-indexing of the calculation field (which filters the letters) to both "Greek" and "ASCII" and it still don't work.

Something weird i seen: When the calculated field is indexed in "Greek" it filters some of the records (not all) and not filtering the first character but any character it finds in a name. If indexed in "English" there's no problem.

I hope this helped a bit.

Andreas smile.gif

Hello Andreas,

It sounds like you are talking about the indexing option for the field which appears in the left-hand column in the define relationships dialog for your portal filtering relationship.

However I was referring to the field which appears on the right, as per the first sentence of my previous post. confused.gif

  • Author

Hi again,

I have tried both sides, individually and together with no results frown.gif

I'm still trying some ways but it seems that the "Greek" characters conflict with others and don't show correctly. Like for ex. say for the "A" character which is the same as the latin "A" but even when filtered with greek names it still only finds a few and not all. I've come over problems like this also with a German program installed on an English version Windows with the greek character support (code pages Greek 737) and some german characters conflict with greek ones which was a real problem.

I'm still in hope for something...

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

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.