AnsweredAssumed Answered

Another SQL question: é

Question asked by Cécile on Nov 10, 2018
Latest reply on Nov 13, 2018 by beverly

This contact picker by J. Young uses the UPPER function to avoid capitalisation-related issues in the search. In Canadian French, UPPER doesn't remove the accent (we accentuate caps) so é becomes É. Sometimes people will enter their names with or without the accent, depending of the person who logs the info, or the input system limitations etc. So sometimes my name is Cécile and sometimes I figure as Cecile in certain databases.

SQL isn't forgiving; if you put the accent in the search it won't find Cecile and if you don't put it, it won't find Cécile.

How can the statement be altered to compare only apples with apples?

 

sqlagain.jpg

Outcomes