-
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';
return
1 John
2 john
3 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
1 JOHN
2 JOHN
3 JOHN
..
works!!!
-
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;
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|