Pros and Cons of a case-sensitive database?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Pros and Cons of a case-sensitive database?

  1. #1
    Join Date
    May 2002
    Posts
    13
    what are they? I have not used a case-sensitive Oracle database and once I heard someone said that it is dumb to make your database case-sensitive. But I don't really know why.

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    I'm not sure what you mean by case sensitive database. I assume you are talking about table and column names??

    Oracle allows case sensitive table/column names. During creation simply surround the table/column name with double quotes:

    CREATE TABLE "MyTable"
    ("Id" NUMBER(10),
    "Desc" VARCHAR2(50));

    The most annoying thing about this is that you constantly have to get the case correct and use quotes in SQL:

    SELECT "Desc"
    FROM "MyTable"
    WHERE "Id" = 10;

    I don't know about you but this really gets on my nerves. I would suggest that this is the reason most people suggest no using case sensitive names.

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  3. #3
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587

    It's definitely annoying. That's why it's dump to make all those upper and lower cases in the data creation.
    Querying is a real pain in those cases.

    Tarry
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  4. #4
    Join Date
    Apr 2002
    Location
    Phoenix, AZ
    Posts
    175
    There are no Pros only Cons.

  5. #5
    Join Date
    May 2002
    Posts
    13
    LOL OK. Problem solved.

  6. #6
    Join Date
    Apr 2001
    Posts
    108

    Kind of a pro for this...

    I can think of one pro for a case-sensitive database schema. Most users won't know to use " " in queries, so it's a type of security. Also some third-party programs don't put the double quotes in their scripts so they won't pull data from a table.

    Not much of a pro, but it's one. I have a database that is case sensitive and it's a real pain to work with. You have to go through the front end app to do anything and the front end is not very friendly, so when I have to work directly within the database it takes a bit more effort.
    Eric Hanson

    There are 10 types of people in the world:

    Those who understand binary and those who don't!

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