Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Fuzzy search index on NVARCHAR

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

Tags:

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question