Fuzzy search index on NVARCHAR
In order to be able to do a text search on a column it has to be declared as a TEXT column. Up to now we have HANA as a secondary database, and apparently all "text-like" columns are translated during replication into type NVARCHAR.
For the text search we then have to declare a fuzzy search index on these columns. This enables this kind of search:
SELECT SCORE() AS score, id, s
WHERe CONTAINS(s, 'Müller', FUZZY(0.5, 'spellCheckFactor=0.9,textSearch=compare'))
ORDER BY score DESC;
In our intake system we have converted our database to HANA (as primary) and I notice that all "text-like" columns are also defined as a NVARCHAR.
Is this the normal way of working? Because the we will also have to define this fuzzy search index on our primary database. This should be automatically done if the conversion translated the columns differently (to TEXT e.g.).
Thanks for any reaction.