I want to send a query to evaluate if a string is already present in a column of a table. I want case insensitive and accent insensitive query.
1. Is there a method in Hibernate to get it or a SQL query that works for all databases?

Thanks

hi, I don't think this is possible with Hibernate nor exists a universal query for accent insensitive search (each RDBMS provide own functions to do it). e.g SQL Server, you can set a collation for the column. Oracle provides this: http://www.rampant-books.com/10g_77.htm

for case insensitive search only take a look at https://www.hibernate.org/293.html

What about Hibernate Search? maybe it provides an ease away to do your requirement....