Hi, usually this can be achieved by using lower() function in index
definition. I guess it should be something like:
CREATE INDEX title_idx ON books (lower(title));
I'm not sure whether Ignite supports such feature, but you can give it a
try.
Btw, to exploit this index you also would have to use lower() function
in you queries as well.
Useful link:
https://use-the-index-luke.com/sql/where-clause/functions/case-insensitive-search
12.01.2023 17:56, Biraj Deb пишет:
Hello,
I am writing to inquire about creating a case-insensitive index in
Ignite's XML Configuration. I have been trying to implement this
feature in my current project, but I am having some difficulty.
I understand that ignite supports case-sensitive indexing by default,
but I would like to know if there is a way to configure it for
case-insensitive indexing. If anyone has experience with this or can
point me in the right direction, it would be greatly appreciated.
Thank you for your time and expertise.
Best regards
Biraj Deb
