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

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-4662?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sharan Foga updated OFBIZ-4662:
-------------------------------
    Sprint: Bug Crush Event - 21/2/2015

> 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: 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 was sent by Atlassian JIRA
(v6.3.4#6332)