Filtering non-latin charecters in portal

[gumstic]

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 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

[CobaltSky]

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

[gumstic]

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

[CobaltSky]

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.

[gumstic]

Hi again,

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

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...