Activiti Query Question

[pp84]

How to query the activiti tables with case insensitivity?

I want to be able to search on variables with case sensitivity disabled. Can someone please advice?

[mitziuro]

I think you can do it easily if your db engine supports COLLATE.
You just have to modify the activiti creation scripts inside the jar:

org/activiti/db/create

For MySQL you can use COLLATE *_ci like:

http://code.openark.org/blog/mysql/mysqls-character-sets-and-collations-demystified

For PostgreSQL you can (create)modify the indexes like this:

http://archives.postgresql.org/pgsql-novice/2011-01/msg00060.php

[pp84]

Can activiti be configured to query ignoring case?