HOW CAN I DO A SEARCH BY NAME IN SAP HANA OMITTED ACCENTS

[Former Member]

hi,

I need to do a search by name in HANA but I want to omit accents, in sql use COLLATE MODERN_SPANISH_CI_AI, how can i do the same in HANA.

thank's

[lbreddemann]

Ok, SAP HANA doesn't support collations as of now (SPS12).

For a flexible search functionality, there are a couple of options available. One approach would be to implement a custom storage of a canonical name and perform searches on that.

Fortunately, SAP HANA comes with build in Text Analytics and Search (check the documentation for details on these).

On the lower end of effort, you might want to look into the CONTAINS() function (http://help.sap.com/saphelp_hanaplatform/helpdata/en/cd/a2d6d0bb571014b7839fa03f84e028/content.htm)