• Anonymous
  • Login
  • Register



JDBC Access for IBM Lotus Domino - Feature Request: Collation for unicode/accent insensitive queries


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?




Taken Actions by Owners

No actions have been taken yet.


Documents
In this field you can enter the actual request.

You can use the rich text editor for rich text formating. You can also enter HTML to embed objects, e.g. to embed a YouTube video or a screenshot of the project. In this case use '[' and ']' to mark the passthrough HTML as such.

Please note that the first time you use the new UI your description is converted from rich text to MIME. You might want to copy and paste the raw plain text from the old UI in the new UI so that you don't loose information.
In this field owners can describe what they have done or want to do.

You can use the rich text editor for rich text formating. You can also enter HTML to embed objects, e.g. to embed a YouTube video or a screenshot of the project. In this case use '[' and ']' to mark the passthrough HTML as such.

Please note that the first time you use the new UI your description is converted from rich text to MIME. You might want to copy and paste the raw plain text from the old UI in the new UI so that you don't loose information.