Hi,
can you please advise as per error below
Endpoint api/v2/accessgroups/serviceagree?query=XYZ "query" take "name" column value from "service_agreement" table. Something like "sql querry ...where service_agreement.name LIKE %query%"
Solution is to define _CI (case insensitive) collation on "name" column on “service_agreement” table in your db, something like this (to give you an idea, not exact command)
ALTER TABLE service_agreement MODIFY (name VARCHAR(128) COLLATE BINARY_CI)
More info about collation you can find here:
Column-Level Collation and Case-Insensitive Database in Oracle Database 12c Release 2 (12.2)
Oracle Database 12c Release 2 (12.2) lets you specify the collation used for columns that hold string data, allowing you to easily perform case insensitive queries, as well as control the order of ...
As after running above alter command, I am getting below error
ALTER TABLE accesscontrol_pandp.service_agreement MODIFY (name VARCHAR(128) COLLATE BINARY_CI)
Error report -
ORA-43929: Collation cannot be specified if parameter MAX_STRING_SIZE=STANDARD is set.
Can you please advise on the collation error?
thanks,
Roshan