How to create a case-insensitive PosgreSQL database for Bonita?
I'm trying to prepare a Bonita server with Postgresql but I do not see in the user's manual how to make a case-insensitive PostgreSQL database.
I think it must be done at creation time using the locale option, but I don't find out which is the parameter I have to put for.
Thank you very much for your help
I'm not aware that we can make the entire DB case insensitive. What are you trying to achieve exactly? Is it for the table/column name or more for the data?
Actually, as far as I know, PostgreSQL does not have any settings to be case insensitive. That is not an issue as Bonita Engine will use for PostgreSQL ILIKE instead of LIKE in WHERE clause definition making the search case insensitive.
So in the end issue is in Bonita documentation that should recommend to apply case insensitive settings only database vendors that requires it (maybe Oracle or SQL Server, MySQL is case insensitive by default if you are using UTF-8 encoding).
Thank you very much for your answer, it has sense, if Bonita uses ILIKE for PostgreSQL then it should not be a problem.