Skip to Content
0
Aug 21, 2015 at 12:47 PM

Fuzzy search index on NVARCHAR

37 Views

Hello all,

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

FROM text_spell_check_factor

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.

Regards.

Kris