解决方法
原来,你可以做一些类似的事情
select upper(convert('This is a têst','US7ASCII')),upper(convert('THIS is A test','US7ASCII'))
from dual;
select 1 from dual
where upper(convert('This is a têst','US7ASCII')) =
upper(convert('THIS is A test','US7ASCII'))
CONVERT将重音字符减少到映射的ASCII等价物,而UPPER将小写字母强制为大写.所得到的字符串应该是匹配的.
