none
No results of SQL Full-Text Search RRS feed

  • General discussion

  • Welcome,


    I have a problem with results of searching by using SQL Full-Text Search.
    The FTS engine not finding the phrase "Zurückweisung". To make it interesting, the phrase "Zurückweisun" (without the last char "g") and "ZurückweisungB" (with the additional char "B") is finding.

    The phrase is searched by a query:

    SELECT * FROM dbo.ftsTest INNER JOIN CONTAINSTABLE(ftsTest, *, ' (FORMSOF (INFLECTIONAL, "Zurückweisung") OR "Zurückweisung*") ', LANGUAGE 1031) [fts] ON [fts].[Key] = [ID] WHERE [fts].[Key] IS NOT NULL

    In case if I change the language to English (LCID: 1033) or I will search without German characters "Zuruckweisung" correct results will be returned.
    The STOPLIST has been cleared from all STOPWORDS (for testing purposes)
    I've added entries in the configuration of trazeurus files already:

    <expansion><sub>Zurückweisung</sub> <sub>Zuruckweisung</sub> <sub>Zurueckweisung</sub> </expansion>

    No matter how I change the query condition, the effect will be similar.
    Even tokenization returns results for both cases:

    SELECT * FROM sys.dm_fts_parser (' (FORMSOF (INFLECTIONAL, "Zurückweisung") OR "Zurückweisung*") ', 1031, 5, 0);

    SELECT * FROM sys.dm_fts_parser (' (FORMSOF (INFLECTIONAL, "Zurückweisung") OR "Zurückweisung*") ', 1033, 5, 0);

    STOPLIST ID equals 5 can be changed to 0

    Do you have any solution or at least a tip that I could check?



    • Edited by Bociek Wednesday, March 20, 2019 10:36 AM
    Wednesday, March 20, 2019 10:35 AM