Fábio Fantato wrote:
Hi Jukka,
I´ve never try it, but I found some tips to use this kind of SQL replacing your collate. Could you please try it in your queries to see if this works?
SELECT {Sorting}.* FROM {Sorting}
ORDER BY @TableSort COLLATE YOURCOLLATENAME_CI_AS
True - that is the "workaround" I am using, but I cannot use e.g. aggregates at all, if I have to search or sort by any text, which includes those Ä,Ö,Å,... characters.
I did it like this..
SELECT {Sorting}.*
FROM {Sorting}
WHERE {Sorting}.[Sortedcolumn] LIKE '%'+ @SearchString + '%' COLLATE Finnish_Swedish_CI_AS
ORDER BY @TableSort
That @TableSort includes that same collation clause that WHERE has (see that screenshot from List_SortColumn).
.. but it still makes it that a little bit harder to all who has those special characters.
Cheers,
-JP