How to create a case-insensitive PosgreSQL database for Bonita?

Submitted by alberto_108 on Mon, 07/17/2017 - 20:46
1
0
-1

Hi,

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.

initdb --locale=????

Thank you very much for your help
Best Regards
Alberto

Comments

Submitted by Lionel Palacin on Mon, 07/17/2017 - 23:01

Hi Alberto,

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?

Permalink
Submitted by alberto_108 on Tue, 07/18/2017 - 02:23

Hi Lionel, Thanks for answering!!

Actually, I do not know, I'm following the instructions Bonita says to configure a different database than H2.
In the following link:
http://documentation.bonitasoft.com/?page=database-configuration
They say:

"Your database(s) must be configured to use the UTF-8 character set. Also, you are recommended to configure the database(s) to be case-insensitive so that searches in Bonita BPM Portal are case-insensitive."

Permalink
2 answers

Submitted by antoine.mottier on Tue, 07/18/2017 - 15:40
1
+2
-1

Hi,

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).

Comments

Submitted by alberto_108 on Tue, 07/18/2017 - 18:28

Hi Antoine,

Thank you very much for your answer, it has sense, if Bonita uses ILIKE for PostgreSQL then it should not be a problem.

Best Regards
Alberto

Permalink

Submitted by emmanuel.duchas... on Wed, 03/10/2021 - 12:06
1
0
-1

To complete Antoine's anwser, the ILIKE trick is only used when Bonita searches for free text, not everywhere there is a A = B in a WHERE query.

Said otherwise, some searches in Bonita are Case-sensitive on PostgreSQL, some are not.

Notifications