I am hitting an Oracle back-end from a rather involved Microsoft Access Front end application. All the Access code, forms, reports, queries etc were developed using access's default of Case insensitivity (originally both front and back-end were Access). Naturally, when we moved the back-end to Oracle, case sensitivity is killing us. Can we have Oracle run in a case insensitive mode?
Any help would be appreciated.
I almost kill myself when I use Acess to do
select id, name from emp where name='John';
case insensitive is the PC feature, to logically turn it off in no-PC envornent, all you need is store same case in database
(e.g. all upper case, or all lower case) then all DB interface
processes use the pre-determined case. it will work perfectly.
use above example,
you will get
If you are unwilling to change the table data as suggested above, you could create a view with the data changed to all one case . . .
create or replace view myview as
select upper(name) name from mytable;
Click Here to Expand Forum to Full Width