Suuport SQL Collate

Plugins SQL
1

Hello!

I’m working witg SQL, I would like to know if OpenDistro SQL support something like “COLLATE” in query request. Specificly:

Latin1_general_CI_AI

I want a query CI & AI (Case Insensitive and Accent Insensitive). Is possible?
Or maybe with another SQL operation?

2

Hi @Itzel, currently OpenDistro SQL do not support the COLLATE feature.