I am trying to do an accent insensitive query in
Using something like :
SELECT * FROM table_name WHERE column_name LIKE '%andre%'
I would like the database to return me a list of rows which column_name are presented with and without accent. column_name solutions such as Alexandre, Andre or André. I already checked SalesForce link : http://www.salesforce.com/us/developer/docs/soql_sosl/index_Left.htm#CSHID=sforce_api_calls_sosl_where.htm|StartTopic=Content%2Fsforce_api_calls_sosl_where.htm|SkinName=webhelp discussing about the different comparison operators but without success.
Has anyone already been confronted to that type of problem in SOQL, and found an answer to it ?