Can you turn off Oracle's Case Sensitivity?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Can you turn off Oracle's Case Sensitivity?

  1. #1
    Join Date
    Mar 2001
    Posts
    2

    Question

    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.

  2. #2
    Join Date
    Nov 2000
    Posts
    245
    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!!!

  3. #3
    Join Date
    Aug 2000
    Posts
    462
    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;

  4. #4
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Simliar thread I just replied to...

    http://www.dbasupport.com/forums/sho...?threadid=8975

    - Chris

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width