[jira] [Created] (OFBIZ-4662) Autocomplete / Suggest does not work with "ß"

[Nicolas Malin (Jira)]

Autocomplete / Suggest does not work with "ß"
---------------------------------------------

                 Key: OFBIZ-4662
                 URL: https://issues.apache.org/jira/browse/OFBIZ-4662
             Project: OFBiz
          Issue Type: Bug
          Components: framework
    Affects Versions: SVN trunk
            Reporter: Christoph Neuroth


When using the quick search boxes with jQuery autocomplete, searching for the German "ß" does not work.

This is related to #4661, but I could not find an easy fix for this. The reason for this is that in FindAutocompleteOptions.groovy ".toUpperCase()" is called and it is then on the database level compared using UPPER(fieldname) LIKE "%FUSS%". toUpperCase() in Java changes "ß" to "SS", while UPPER() at least in Postgres 9.1 using UTF8 collation does not change the ß at all.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira