Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-2448

Troubles with umlauts in full-text search (JCR-SQL2)

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 4.2.0.Final
    • Fix Version/s: 4.3.0.Final
    • Component/s: Query
    • Labels:
      None

      Description

      Hello modeshape team,

      we're having troubles with full-text search in combination with umlauts.

      Generally full-text search is case insensitive, but it looks like it's case sensitive for umlauts contained in the search text.

      Let's assume we have a content having a property called title with the value 'Änderung'.

      Here is our example query:
      select * from [content] where CONTAINS(title, $searchText)

      If searchText is replaced with 'änderung' then the query doesn't return any results.
      If we change the searchText to uppercase ('ÄNDERUNG') or remove the umlaut ('nderung', 'NDERUNG') the query returns the expected results.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                hchiorean Horia Chiorean
                Reporter:
                javagirlie Susanne Königstorfer
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: