Scandinavian ø character

[Screbinodus]

I'm having a problem trying to find on names containing the Scandinavian 'ø' character. On FM6, this was treated as a match for a regular letter 'o' (i.e. a search for 'Hof' would return both 'Høffer' and 'Hoffmann' in the found set).

We then upgraded to FM server 8 and client 8, and the character was treated as a distinct letter (i.e. you would have to remember to search for 'H*f' to be sure to find both names.

I couldn't find a solution for this at all, and I wasn't sure whether it was occuring at the level of the field, file, application or even the OS (Windows Server 2003).

The problem disappeared when we switched to filemaker server 9/Client 9 (again on Windows Server 2003), and I thought no more about it.

Last week we upgraded to FM server 10 (on Windows Server 2008), and the problem returned!

Can anybody suggest what I can do about this? It would be most useful to be able to find based on a regular 'o'!

[Søren Dyhr]

What does the the DDR tell about the indexing language? My guess is that if you turn it to danish/norwegian would you be able to distinguise, since Dutch IMHO sould be a subset of this indexing.

--sd

[Screbinodus]

The indexing language is English -- we're an international school, with about 70 differnt nationalities!

[Søren Dyhr]

Which would you then consider a subset of the other, change to Danish/Norwegian which are larger ... but It then makes the German sort wrongly...

It's not an easy thing to solve!

--sd

[Screbinodus]

Is it possible to create a custom indexing rules? I know exactly what I need, and which character to treat as others!

[Søren Dyhr]

Good question, you can sort based on a valuelist ... but to make it stick in searches as well, seems to call out for some sort of workaround!

Something in the vicinity of this:

http://www.newcenturydata.com/downloads/filter.zip

--sd

[Screbinodus]

Custom value lists are OK, but it relies on contraining the searching to certain layouts where I've set up a search portal -- it'd be nice to be able to set these rules for any old find in any layout.

Cheers!

J.

[lesjokolat]

Check out fx.php for filemaker this allows users to enter and manipulate data(web data) with utf-8 data thereby helping your issue of scandinavian æøå iviking.org i beleive is the site.

lykk til