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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 4.3.0.Final
    • 4.2.0.Final
    • Query
    • None

      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.

              hchiorean Horia Chiorean (Inactive)
              javagirlie Susanne Königstorfer (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: