惭愧,没法真正解决...... SQL> select * from test_1 where name like lower('A'); ID NAME PART ---------- ---------- ---------- 1 a aaSQL> select * from test_1 where name like upper('a'); ID NAME PART ---------- ---------- ---------- 2 A AA仅做参考。
ORACLE查询后,在你的前台处理一下不就行了。
10G用户可以考虑一下 ALTER SESSION SET NLS_SORT=JAPANESE_M_CI; --(change it to sth. chinese) ALTER SESSION SET NLS_COMP=ANSI;
将ALTER SESSION SET NLS_SORT=JAPANESE_M_CI; 换成ALTER SESSION set nls_sort=binary_ci;
SQL> select * from test_1 where name like lower('A'); ID NAME PART
---------- ---------- ----------
1 a aaSQL> select * from test_1 where name like upper('a'); ID NAME PART
---------- ---------- ----------
2 A AA仅做参考。
ALTER SESSION SET NLS_SORT=JAPANESE_M_CI; --(change it to sth. chinese)
ALTER SESSION SET NLS_COMP=ANSI;
换成ALTER SESSION set nls_sort=binary_ci;