Geoff hendrey wrote:
I posted a comment with a suggestion on an approach for dealing with
case-insensitive comparisons.
Any feedback?
https://issues.apache.org/jira/browse/DERBY-1748?focusedCommentId=12606166#action_12606166
I find declaring the collation when defining the column is much more
useful as it then automatically applies to all comparisions/indexes
involving the column. Allowing more options when specifying the database
collation would be a useful starting point (as suggested by Debrunner).
Mark Thornton