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
