Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-29900

Implement accent insensitive search on directories for PostgreSQL

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.10
    • Fix Version/s: HOTFIX_10.10, 11.x
    • Component/s: Directory

      Description

      Currently the search on directories is case insensitive only (and always) and uses the ILIKE operator for PostgreSQL (or the LOWER ... LIKE for databases which does not support ILIKE operator).

      This request is to provide a solution for people who wants to run accent insensitive queries on directories :

      • on PostgreSQL, using the unaccent extension provides this capability
      • on Oracle, using a specific collation should do the trick

      So this ticket is to provide a solution for PostgreSQL only.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: