Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 08, 2016 at 02:48 AM

    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)

    Add comment
    10|10000 characters needed characters exceeded