I have an application where users can search for last name, first name, address, etc.
I've managed to get unicode case insensitive searches working by converting the lookup value to upper case and adding UPPER around the field name in the query.
E.g. SELECT * FROM people WHERE UPPER(firstName)='ØYVIND'
I've yet to discover how to do accent insensitive queries. If I want all people named Per, regardless of accent (e.g. Pér).
I couldn't find a way to create a custom collation at runtime. If possible, could you add a UTF-8 case insensitive/accent insensitive collation?