Question

Retrieve From Data Base(Oracle) is case sensitive, Is there a way to do a retrieve that is NOT case sensitive.

1

Retrieve From Data Base(Oracle) is case sensitive, Is there a way to do a retrieve that is NOT case sensitive. I cant use a toLower or Uppercase in the X-path. Is there a Quick fix for this or will i have to force Upper or lower case on commit and then when a do my retrieve force the field i am using to the same case.

asked 2011-08-29

Patrick Gerardi

1 answers

Sebastiaan van den Broek · Answer 1 · 2011-08-29

The 'contains' and 'starts-with' function in xpath are case insensitive, there is no way to set an entire database to be case insensitive in oracle as far as I know.