views:

29

answers:

0

I've implemented a simple suggestive keyword autocomplete plugin that reads off the sys.dm_ftw_index_keywords table as follows:

SELECT top 5 words.display_term, SUM(words.document_count) as c
FROM sys.dm_fts_index_keywords (db_id(), object_id('testtable')) words
WHERE (display_term LIKE '%test%' AND keyword != 0xFF)
GROUP BY words.display_term
ORDER BY c DESC

This seems to be working fine with English words. Though to my surprise that all my French words are also stored in the same table, just with all their accents removed. This becomes a problem since I'll not be able to provide suggest words for French users. So I'm wondering if there's any workarounds?

P.S. I tried putting all the French content in a separate FullText Accent Sesitive catalog, but the words are still stored without the Accent.

P.S. Also I'm wondering if using sys.dm_ftw_index_keywords would have any negative performance impact or should I just build a keywords table on my own?