When you run the function for fulltext sys.dm_fts_parser returns different results if you write the word accented or not. The system interprets them as different words.
Query 1:
Código SQL:
Ver originalSELECT * FROM sys.dm_fts_parser(N'FORMSOF(FREETEXT, "Técnicos")', 3082, 0, 0); Results: tecnicos,tecnico,tecnicas,tecnica
Query 2:
Código SQL:
Ver originalSELECT * FROM sys.dm_fts_parser(N'FORMSOF(FREETEXT, "Tecnicos")', 3082, 0, 0); Results: tecnicos
WhWhat is the solution to return the same results Técnicos and Tecnicos?