Problems with german 'ß' and ViewCriteriaRow.setUpperColums
357058Mar 4 2004 — edited Mar 11 2004The is a principal problem to use ViewCriteriaRow.setUpperColumns if the criteria value contains the german 'ß' (sz) character which exists only in lower case. This is because SQL upper keeps 'ß' unchanged but String.toUpperCase converts 'ß' to 'SS' (double 'S'). But with this the query generated from such view criteria always returns no rows because 'ß' does not match 'SS'. So the jbo:ViewCriteriaIterate-Tag cannot be used for case insensitive search.
It would better to use lower / toLowerCase instead. A work around for this problem is difficult because the behaviour of SQL upper and / or String.toUpperCase cannot be changed and it is difficult to change the SQL generator.
Any hints for a solution?
Michael Seyfried
Europäische Reiseversicherung AG, Munich, Germany