You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Christoph Neuroth (Created) (JIRA)" <ji...@apache.org> on 2012/01/16 16:30:41 UTC
[jira] [Created] (OFBIZ-4662) Autocomplete / Suggest does not work with "ß"
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