–Set the comparison to LINGUISTIC alter session set NLS_COMP=LINGUISTIC; –Set the SORT to GENERIC_M_AI (AI means Accent insensitive, and case insensitive) alter session set NLS_SORT=GENERIC_M_AI; –Create a table and load some data CREATE TABLE test_query (my_text VARCHAR2(100)) / insert into test_query (my_text) VALUES (‘test-‘); insert into test_query (my_text) VALUES (‘TEST-‘); insert into test_query (my_text) VALUES […]