CREATE TABLE t1 (
id NUMBER,
col varchar2(15),
CONSTRAINT t1_pk PRIMARY KEY (id)
)
Table created.
INSERT INTO t1 VALUES (1, 'jose')
1 row(s) inserted.
INSERT INTO t1 VALUES (2, 'Jose')
1 row(s) inserted.
INSERT INTO t1 VALUES (3, 'JOSE')
1 row(s) inserted.
INSERT INTO t1 VALUES (4, 'José')
1 row(s) inserted.
INSERT INTO t1 VALUES (5, 'JOSÉ')
1 row(s) inserted.
COMMIT
Statement processed.
CREATE INDEX idx_t1_col_ci ON t1(NLSSORT(col, 'NLS_SORT = BINARY_AI'))
Index created.
alter session set NLS_COMP='LINGUISTIC' ;
Statement processed.
select * from NLS_SESSION_PARAMETERS where parameter in ('NLS_COMP','NLS_SORT')
PARAMETER | VALUE | NLS_SORT | BINARY_AI | NLS_COMP | LINGUISTIC |
---|
select col from t1 where col LIKE '%jose%'
COL | jose | Jose | JOSE | José | JOSÉ |
---|