Problem using white space in the People form field

Flowable Engine
5

Yvo,

When you say “involve database specific implementations” are you saying that each database uses a different notation for Concatenation? Ex: PostgreSQL = “||”, MySQL = “Concat”, SQL Server = “+”.
I believe it can have three possible paths:

  1. Create a condition to check which database and create distinct SQLs for each database.
  2. Use the properties file of each database to create a variable that defines a concatenation operator.
  3. Create a View that returns a FullName field with the concatenation of First and Last name. The creation of the view should be added to the Bank creation script.
  4. Create a concatenation function in each data structure creation SQL script

Which option do you think is the best option?