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

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

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

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

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

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

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.

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