This discussion is archived
3 Replies Latest reply: Mar 20, 2012 10:45 AM by P.Forstmann RSS

long char data type

924779 Newbie
Currently Being Moderated
Is there a data type in Oracle that is longer then 4000 bytes and does not have the restrictions of LOB or LONG data types?
  • 1. Re: long char data type
    P.Forstmann Guru
    Currently Being Moderated
    The right character type for character data larger than 4000 bytes is CLOB.

    LONG data type has a lot of restrictions which CLOB data type does not have: what are CLOB restrictions you are facing ?
  • 2. Re: long char data type
    924779 Newbie
    Currently Being Moderated
    the CLOB restrictions that i am facing are:

    1. cannot specify a LOB as a primary key column.

    2. cannot specify LOB columns in the ORDER BY clause of a query, or in the GROUP BY clause of a query or in an aggregate function.

    3. cannot specify a LOB column in a SELECT... DISTINCT or SELECT... UNIQUE statement or in a join.

    I am trying to create fields that can contain both short names and long text.

    Edited by: 921776 on Mar 20, 2012 9:23 AM
  • 3. Re: long char data type
    P.Forstmann Guru
    Currently Being Moderated
    But do you really need to have a primary key column longer than 4000 bytes or to sort by column longer than 4000 bytes ?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points