The problem was because the schema on the flowconnect database used columns with the data type NCHAR and these were not considered as suitable candidates for searching. It only searched,
VARCHAR
NVARCHAR
LONGVARCHAR
LONGNVARCHAR
To fix the problem I’ve added support for NCHAR and CHAR
The change consists of just a couple of lines in src/main/java/com/manywho/services/sql/services/filter/QueryFilterConditions.java
The remaining changes are searching tests for MySQL, Postgres and SQl Server
The problem was because the schema on the flowconnect database used columns with the data type NCHAR and these were not considered as suitable candidates for searching. It only searched,
To fix the problem I’ve added support for NCHAR and CHAR
The change consists of just a couple of lines in src/main/java/com/manywho/services/sql/services/filter/QueryFilterConditions.java
The remaining changes are searching tests for MySQL, Postgres and SQl Server