Skip to Content
0

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

Nov 07, 2016 at 11:34 PM

30

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lars Breddemann
Nov 08, 2016 at 02:48 AM
0

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)

Share
10 |10000 characters needed characters left characters exceeded