Accent-Insensitive search and LIKE
Hello,
I'm not sure if I am posting my question in the right place as I was unable to find a community that is specific to globalization. Kindly redirect me if I am in the wrong place
My general question is: What is the correct way to do accent-insensitive searches while using the LIKE operator? I cannot get it to work consistently.
More specifically. I have the following settings:
alter session set nls_sort=punctuation; -- At a client's site, this can be swedish, german, arabic, etc.
alter session set nls_comp=linguistic;
With the following example data:
create table t(a varchar2(50));
More specifically. I have the following settings:
alter session set nls_sort=punctuation; -- At a client's site, this can be swedish, german, arabic, etc.
alter session set nls_comp=linguistic;
With the following example data:
create table t(a varchar2(50));
0