Case

  • Hi ,

    In Oracle all data in tables is case-sensitive but the database objects are

    case-insensitive .

    can i install sql server that act like oracle ?

    thank you .

  • Don't think so. I think the sort order while apply for both tables and data.

    Steve Jones

    steve@dkranch.net

  • Thank you .

    🙂

  • You're welcome. One other thing I though of is that if you declare the objects with case sensitive names (like columns), they will be returned as such. This must be maintained by users, but it works.

    Steve Jones

    steve@dkranch.net

  • Actually you can in regards to making data case-sensitive, by default it is not. It is available under custom. As you go thru custom it will get to the point where you can set this along with unicode colation (spelled wrong here I am sure).

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply