Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2006
    Posts
    119

    Unanswered: Case Sensitivity

    Hi,
    1. Is Oracle case sensitive or insensitive by default?
    2. Obviously, I can check this my running a few simple queries, but I was just wondering is there a Session property that I can check?
    Thanks.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Quote Originally Posted by Breako
    Hi,
    1. Is Oracle case sensitive or insensitive by default?
    2. Obviously, I can check this my running a few simple queries, but I was just wondering is there a Session property that I can check?
    Thanks.
    I'm pretty sure that writing a simple query would have been quicker than posting here.
    The answer is: by default yes, but you can change it.

    For the second part of your question see the manual:

    Linguistic Sorting and String Searching

  3. #3
    Join Date
    Jan 2006
    Posts
    119
    Quote Originally Posted by shammat
    I'm pretty sure that writing a simple query would have been quicker than posting here.
    The answer is: by default yes, but you can change it.
    I did that. But my DB may not have been at default settings. My question was about default settings.

  4. #4
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Quote Originally Posted by Breako
    I did that. But my DB may not have been at default settings.
    Then you should have told us that.
    If you are unsure about the queries then post the queries and concrete questions.

    Everything else is in the manual

  5. #5
    Join Date
    Jan 2006
    Posts
    119
    Quote Originally Posted by shammat
    Then you should have told us that.
    If you are unsure about the queries then post the queries and concrete questions.
    The specifics of the query have nothing to do with it. It's the default behaviour I was looking for, which I mentioned clearly in OP.

  6. #6
    Join Date
    Feb 2004
    Posts
    193
    Seems like we have some posting sensitivity here.

    ddave

Posting Permissions

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