Case Sensitivity on Oracle Link

[Tim]

Our organization uses Oracle for our back end database.

Our network people hooked my copy of Access 2000 up to it.

Any queries I do on the data are case sensitive.

I find this extremely annoying.

Is there a fix? Can Oracle or Access be set up to
eliminate this problem?

I know I can import the tables into the Access
environment to get rid of case sensitivity. However, I
really want a live link.

 

[Douglas J. Steele]

I don't really know Oracle that well, but I know that case sensitivity is
something you can turn on or off for SQL Server, so I'd assume Oracle is the
same. There's nothing you can do from within Access, though (other than
issue the command to Oracle)

 

[Lynn Trapp]

Typically, Oracle SQL is NOT case sensitive, except for text literals or
quoted names. Just exactly what problem are you encountering?

 

[Xi Luan]

In you query criteria use Lcase() or Ucase() to wrap your
text to compare.

Luan

 

[Joe Fallon]

I deal with the same issue a lot.
It is a pain.
If your data is all uppercase then just be sure to query it that way.
If you use an Uppercase function during your compare, I suspect it will be
extremely slow and may pull all the data over the wire to evalute the
function. (You don't want to do this!)
If you use a Pass Through query, you get a read only result but then you can
use Oracle syntax for upper casing and the work is done on the server.