Hello,
Search Server treats å,ä,ö characters as a,a,o when i order by title i.e. Is there some way to make the search result to order them correctly?
Best regards, Mattias
A:
The concept you are looking for is called collation. Read more about it here.
klausbyskov
2010-04-22 09:07:34
Search Server requires Latin1_General_CI_AS_KS_WS to be used. I dont know if you could use collation in the specific SQL-query when performing a search. I dont have the possibility to try it out atm. Anyone know if its applicable?
Mattias
2010-04-22 09:14:40
You can define the collation on a query, using a query operator `COLLATE` : http://msdn.microsoft.com/en-us/library/ms184391.aspx
ANeves
2010-04-22 09:22:40
I tried but COLLATE doesnt seem to be supported in the web service query in Search Server. In regular queries outside Search Server its doable, but not in this case due to some restrictions apparently. Ive reported it to microsoft
Mattias
2010-04-22 13:23:31